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
    priyaram, Feb 23, 2007
    #2

  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
    MohammedU, Feb 23, 2007
    #2

  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.
    satya, Feb 24, 2007
    #2

Share This Page