How to find the expiry date for SQL Server 2012 Evaluation

On 30 May, 2015

T-SQL

By : Dave Jenkins

No Comments

Did you install SQL Server 2012 Standard Edition for evaluation purposes on your PC and forgot to write down when your six months is up? Yep, you’re right, I’m talking from experience here! So I needed some T-SQL magic to help me and here it is for you:

SELECT
    create_date AS 'Install Date',
    DATEADD(DD, 180, create_date) AS 'Expiry Date'
FROM 
	sys.server_principals
WHERE
	name = 'NT AUTHORITY\SYSTEM'

SELECT

create_date AS 'Install Date',

DATEADD(DD, 180, create_date) AS 'Expiry Date'

FROM

sys.server_principals

WHERE

name = 'NT AUTHORITY\SYSTEM'

It’s nice and simple we simply find the install and 180 days (6 months) onto it using DATEADD(). That should stop the pain when a pop up tells the evaluation period has ended.

Tags : SQL Server 2012 T-SQL

Previous Post Next Post

About The Author

Dave Jenkins

Hello! I'm Dave Jenkins and I have been working with MS SQL Server for two years. I'm an MCP (70-461) working towards an MCSA. I love working with MS SQL Server and the BI Stack.

Number of Posts : 26

All Posts by : Dave Jenkins