Determining SQL Server Up Time or Last Time Rebooted

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  September 1, 2009 at 1:44 pm

  #156160

  We are running SQL Server 2000 SP4 on Windows 2003 Server. Is there a Windows DOS Command which determines the uptime of the machine or the last time the machine was rebooted? Or, is there an SQL Extended Stored Procedure that would return this information?

  Thanks in advance, Kevin

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  September 1, 2009 at 1:53 pm

  #1047795

  net statistics server

  or

  systeminfo

  -Roy

• matt6288

  SSCertifiable

  Points: 5058

  More actions

  September 1, 2009 at 2:00 pm

  #1047797

  SELECT create_date FROM sys.databases

  WHERE NAME = 'TEMPDB'

  EDIT: Sorry this will return the last time the SQL service was started.