How to Check SQL Server Installation Date

Ever tried to determine when the SQL Server instance was installed? You can execute the following query and see the create_date column in the result –

SELECT create_date, * FROM sys.server_principals
WHERE NAME = 'NT AUTHORITY\SYSTEM'

NT AUTHORITY \ SYSTEM is the principal that is created when SQL Server instance is installed.

Advertisements