mchofman (2/4/2010)
Lars,you can also retrieve the start time from this Dynamic Management View
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
(Requires VIEW SERVER STATE permission on the server)
Marco
Hi Marco
That's correct for SQL Server 2008. The sqlserver_start_time in sys.dm_os_sys_info was added in SQL Server 2008 and wasn't there in SQL Server 2005.
Using the tempdb works for all our current versions 🙂 (yes, we still have SQL Server 2000)
Kind regards
Lars