Sql Server Service

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.