Thursday, July 5, 2012

Retrieve SQL Server Installation Date Time

SQL Server Installation date


SELECT create_date
FROM sys.server_principals
WHERE sid = 0x010100000000000512000000


-- Evaluation Version Expire Date

SELECT create_date AS InstallationDate,
DATEADD(DD, 180, create_date) AS 'Expiry Date'
FROM sys.server_principals
WHERE sid = 0x010100000000000512000000
 

No comments:

Post a Comment