Many times we want to know when SQL Server was last started.
For this here is a simple way
As we know tempdb always recreated when SQL Server starts , so from create_date of tempdb we can get idea when the server was started.
select create_date from sys.databases where name = ‘tempdb’
This entry was posted on March 13, 2009 at 3:34 pm and is filed under SQL Server - Troubleshooting. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Lets SQL 
Leave a comment