November 12, 2018 at 1:57 am
How do I find out license expiration dates across all versions of sql servers using sql.
November 12, 2018 at 2:39 am
unless you are using a evaluation version then you won't have it.
otherwise the SQL Server license does not expire.
If you have SA this does expire if you do not pay for renewal - but this will not be stored anywhere on the SQL itself.
November 14, 2018 at 10:09 am
There isn't an expiration date, as noted, for licenses editions. For evals, use this:
SELECT
@@SERVERNAME SERVERNAME,
CREATE_DATE ‘INSTALALTIONDATE’,
SERVERPROPERTY(‘EDITION’) ‘Version’,
DATEADD(DD, 180, CREATE_DATE) AS ‘EXPIRY DATE’
FROM SYS.SERVER_PRINCIPALS
WHERE SID = 0X010100000000000512000000
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply