Blogs

.NET to SQL to Project Server and everything in between
Welcome to Blogs Sign in | Join | Help
in Search

Strate SQL

Last Time SQL Server Restarted

Not a really hard thing to figure out, but for some crazy reason I always forget.  So, hopefully actually writing it out for the world to see will help me remember.

Since tempdb is created every time that SQL Server restarts, the created date for that database can be used to determine the last time the SQL Server restarted. 

SELECT create_date FROM sys.databases WHERE name = 'tempdb

Yeah... really hard, hehe.

Published Tuesday, July 01, 2008 11:25 AM by Jason
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(optional)
(required) 
Submit
Powered by Community Server, by Telligent Systems