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
at

2 comments:

  1. Anonymous12:50 PM

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

    ReplyDelete
  2. Denis12:06 PM

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

    ReplyDelete