Home Forums SQL Server 2008 SQL Server 2008 - General When was server last rebooted? RE: When was server last rebooted?

  • November 14, 2012 at 12:48 am

    #1558761

    yuvipoy (11/14/2012)

    you can get the time by running this query also

    Select name,crdate from sys.sysdatabases where name='tempdb'

    That gets you the time the SQL instance was last started, not the time the server was last rebooted.

    sysdatabases is deprecated, should not be used, included only for backward compat with SQL 2000, will be removed in a future version. The replacement is sys.databases

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass