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

2 comments:

Anonymous said...

Don't you mean, when was the last time the service was started?

Denis said...

Yes you are right, when I said 'server' I meant SQL Server not Windows Server