Jaa


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