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?
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