Error message:
Invalid column name 'sqlserver_start_time'.
Cause:
Column 'sqlserver_start_time' in sys.dm_os_sys_info was added in SQL Server 2008.
If you try to select it in SQL Server 2005/2000 you will get this error.
Solution:
Find SQL Server last restart time from sys.dm_exec_sessions or from tempdb creation time:
SELECT create_date FROM sys.databases WHERE name = 'tempdb'
SELECT login_time FROM sys.dm_exec_sessions WHERE session_id = 1
No comments:
Post a Comment