SQL Server Performance

When was my Server restarted?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jun 9, 2008.

  1. Anonymous New Member

    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'...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/06/09/4442.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4442" width="1" height="1">

Share This Page