June 2008 - Posts

When was my Server restarted?

 

Temporary database tempdb is created whenever the Server is restarted. So you can know when Server was restarted by knowing the creation date of the tempdb

EXEC sp_helpdb tempdb

select crdate  from master..sysdatabases
where name='tempdb'

Posted by Madhivanan with 1 comment(s)
Filed under: ,