Sql Server Service

Question

hi I want to know how to programmatically find out when the sql server service started?

Kunal Naik · Answer

Hi There is one simple but awkward method is there to find out when the SQL server service is started . The following query will give you the time when the SQL server service is started ; select crdate from [master].dbo.sysdatabases where name='tempdb' This is because the tempdb will be created whenever SQL server service is started or restarted. SELECT login_time FROM sys . dm_exec_sessions WHERE session_id = 1 will give you a datetime for when the server was started. Hope this will helps you.