http://www.sqlservercentral.com/blogs/mssqlfun/2014/07/17/how-to-check-sql-server-installation-date-time-/

Printed 2014/12/26 10:58PM

How to Check SQL Server Installation Date Time ?

2014/07/17

You need to run the following query and it will give you the date of your SQL Server Installation.

SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’

FROM SYS.SERVER_PRINCIPALS

WHERE SID = 0X010100000000000512000000

SID 0X010100000000000512000000 is belongs to user "NT AUTHORITYSYSTEM". This user create at the time of installation only.

If you liked this post, do like on Facebook at

Reference : Rohit Garg ()



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.