Home Forums Article Discussions Article Discussions by Author Discuss content posted by Lars Søe Mikkelsen How long has passed since SQL Server service started? RE: How long has passed since SQL Server service started?

  • February 4, 2010 at 2:26 am

    #1113561

    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