SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The expiration date is always 180 days from the initial installation date.
The following query will give you the expiration date of evaluation instance :
SELECT
@@SERVERNAME SERVERNAME,
CREATE_DATE ‘INSTALALTIONDATE’,
SERVERPROPERTY(‘EDITION’) ‘Version’,
DATEADD(DD, 180, CREATE_DATE) AS ‘EXPIRY DATE’
FROM SYS.SERVER_PRINCIPALS
WHERE SID = 0X010100000000000512000000
SID 0X010100000000000512000000 is associated with login “NT AUTHORITYSYSTEM” & which is created at the time of installation only.
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)
Or you can simply peek into the Start Time value in %Program Files%Microsoft SQL Server110Setup BootstrapLOGSummary.txt file and add 180 days to it.
I personally prefer looking into the registry.
Thanks Good one.
Thank You.
SELECT
@@SERVERNAME SERVERNAME,
SERVERPROPERTY(‘Edition’) AS Edition,
CREATE_DATE ‘INSTALALTIONDATE’,
SERVERPROPERTY(‘EDITION’) ‘Version’,
DATEADD(DD, 180, CREATE_DATE) AS ‘EXPIRY DATE’
FROM SYS.SERVER_PRINCIPALS
WHERE SID = 0X010100000000000512000000
You could certainly see your skills within the
work you write. The arena hopes for more passionate writers like you who are not afraid to say
how they believe. At all times follow your heart.
After SQL Server Evaluation Edition period expired.. How can we continue or how we have to renew the licence of SQL server 2014??.
We have upgrade option available in setup wizard.
I see your page is similar to my page. Do you allow guest posting?
I can write interesting & unique posts for you.
Let me know if you are interested.
You can contact via garg.work@gmail.com for guest posts.
It’s NOT WORKING !!!!!!
Msg 208, Level 16, State 1, Line 1
Invalid object name ‘SYS.SERVER_PRINCIPALS’.
Which Version you are using?
Modify above query like 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