Blog Post

SQL Server Installation Date

,

I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items that came up that would like to collected is the date that SQL Server was installed on the server.  In doing a quick search on where this property would be located I found that sys.server_principals would hold the key. 

The principal “NT AUTHORITY\SYSTEM” should always have a sid of ’0×010100000000000512000000′ and its created_date would be when SQL Server was installed. 

Knowing this you can determine when SQL Server was installed using TSQL using the following script.

SELECT create_date
FROM sys.server_principals
WHERE sid = 0×010100000000000512000000

This works on SQL 2005 and above.

 

Share

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating