SQL 2008: A new method for finding the SQL instance start time

There are several methods you could use in SQL Server 2005 to determine when the SQL Server instance started up - however SQL Server 2008 introduces a quick and direct method by querying the sqlserver_start_time column from the sys.dm_os_sys_info DMV (example below):

SELECT sqlserver_start_time
FROM sys.dm_os_sys_info

Comments

• Anonymous
  January 07, 2009
  PingBack from http://www.codedstyle.com/sql-2008-a-new-method-for-finding-the-sql-instance-start-time/