How to Programmatically Identify When Your SQL Server Was Last Started

Where do you go to find the last time SQL Server was started?  I’m guessing you might have gone to the ERRORLOG file and reviewed it to determine when SQL Server started.  That method will work.  But what if you programmatically want to script a way to identify when SQL Server was last started.  How would you do that?

There is a simple TSQL way to programmatically identify the last time SQL Server was started.  Here is the code to accomplish this:

SELECT login_time FROM sys.dm_exec_sessions WHERE session_id = 1;

See all articles by Greg Larsen

Gregory Larsen
Gregory Larsen
Gregory A. Larsen is a DBA at Washington State Department of Health (DOH). Greg is responsible for maintaining SQL Server and other database management software. Greg works with customers and developers to design and implement database changes, and solve database/application related problems. Greg builds homegrown solutions to simplify and streamline common database management tasks, such as capacity management.

Latest Articles