Browse by Tags

• sql server

When was my Server restarted?
09 June 08 01:35 PM | Madhivanan | 2 Comments   

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' Read More...

Filed under: sql server, tempdb