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'...(<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">