Wednesday, 4 July 2012

Get SQL server Installation and expiry date

Query to get Installed and expiry data of SQL
-- Evaluation Version Expire Date
SELECT create_date AS InstallationDate,
DATEADD(DD, 180, create_date) AS 'Expiry Date'
FROM sys.server_principals
WHERE sid = 0x010100000000000512000000
GO

No comments:

Post a Comment