Blog Pages

SQL Server: Invalid column name 'sqlserver_start_time'.

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