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/