Browse by Tags

All Tags » tempdb (RSS)

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 no comments
Filed under: ,