Login or Sign Up to become a member!

EXPERTS, INFORMATION, IDEAS & KNOWLEDGE

Social bookmarker Add this

SQL Server 2008: When Was The Server Last Started?

From Wiki

Jump to: navigation, search

SQL Server 2008 has an additional column in the sys.dm_os_sys_info Dynamic Management View. The name of the column is sqlserver_start_time and it will be the time SQL Server was last restarted

  1. SELECT sqlserver_start_time FROM sys.dm_os_sys_info


Contributed by: --SQLDenis 01:18, 6 June 2008 (GMT)

Part of SQL Server Admin Hacks

338 Rating: 0.0/5 (0 votes cast)