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