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'

Published 09 June 2008 16:24 by Madhivanan
Filed under: ,

Comments

No Comments