SQL Server Performance

when upgraded

Discussion in 'SQL Server 2005 General DBA Questions' started by priyaram, Feb 23, 2007.

  1. priyaram New Member

    is there a tsql or stored proc to find when was the sqlserver got upgraded from 2000 to sqlserver 2005?

    thanks in advance
  2. MohammedU New Member

    Check your log file last modified date in C:program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles folder.
    It can be checked by using xp-cmdshell command...


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. satya Moderator

    Or if you can query the system tables in SQL 2005 - sysindexes.keys or sysdevices.size and if returns NULL then it is an upgraded database.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page