Home » CodeProject » How to Check SQL Server Evaluation Version Expire Date ?

How to Check SQL Server Evaluation Version Expire Date ?


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/)

Advertisements

6 Comments

  1. ArthurZ says:

    Or you can simply peek into the Start Time value in %Program Files%\Microsoft SQL Server\110\Setup Bootstrap\LOG\Summary.txt file and add 180 days to it.

  2. Deepak Mansukhani says:

    I personally prefer looking into the registry.
    Thanks Good one.

  3. Fazar says:

    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

  4. bệnh ung thư phổi says:

    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.

  5. janardhan says:

    After SQL Server Evaluation Edition period expired.. How can we continue or how we have to renew the licence of SQL server 2014??.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: