Thursday, February 07, 2008
SQL Server 2008: When Was The Server Last Started?
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
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
Labels:
Dynamic Management View,
SQL Server 2008
Subscribe to:
Post Comments (Atom)
2 comments:
Don't you mean, when was the last time the service was started?
Yes you are right, when I said 'server' I meant SQL Server not Windows Server
Post a Comment