locked
SQL Server enterprise core 2012 sp1 RRS feed

  • Question

  • Hello,

    I upgraded sql server 2008 r2 sp1 to sql server 2012 r2 sp1.

    My product key reside in installation process.

    Now I am trying to check if version is trial or not.

    So I found one query that I executed.

    http://www.tech-recipes.com/rx/38765/sql-server-2012-find-expiry-date-of-sql-server/

    SELECT  create_date AS 'SQL Server Installed Date',
        Expiry_date AS 'SQL Server Expiry Date',
        DATEDIFF(dd,create_date, GETDATE()) 'No_of_Days_Used',
        ABS(DATEDIFF(dd,expiry_date,GETDATE())) 'No_Of_Days_Left'
    FROM
    (SELECT sp.create_date,
        DATEADD(dd, 180, sp.create_date) AS Expiry_date
     FROM   sys.server_principals sp
     WHERE  sp.name = 'NT AUTHORITY\SYSTEM') as exp_date_tbs

    Now when I executed this query it says 179 days left.

    And when I did edition upgrade from maintenance, then it says 179 days left.

    How could I convert trial edition to full edition?

    Thanks

    Friday, July 1, 2016 7:16 PM

Answers

  • Well, do not worry about if your version is not Evaluation Edition. It is only valid if It is Evaluation edition

    check if your version really is EVALUATION --Select @@version -- do you see ENTERPRISE EVALUATION EDITION in there..

    The code- is really checking when sql is installed and adding 180 days to it to calculate the expiry date..

    so, it does not matter for other editions except EVALUATION.


    Hope it Helps!!

    Friday, July 1, 2016 7:32 PM

All replies

  • Well, do not worry about if your version is not Evaluation Edition. It is only valid if It is Evaluation edition

    check if your version really is EVALUATION --Select @@version -- do you see ENTERPRISE EVALUATION EDITION in there..

    The code- is really checking when sql is installed and adding 180 days to it to calculate the expiry date..

    so, it does not matter for other editions except EVALUATION.


    Hope it Helps!!

    Friday, July 1, 2016 7:32 PM
  • No.

    When I executed following code:

    SELECT 'SQL_Server_Edition' AS 'Verion', SERVERPROPERTY('Edition') AS Type_Of_Edition
    UNION
    SELECT 'Version', @@VERSION

    It get output from below:

    Verion Type_Of_Edition
    SQL_Server_Edition Enterprise Edition: Core-based Licensing (64-bit)
    Version Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) 
    Oct 19 2012 13:38:57 
    Copyright (c) Microsoft Corporation
    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


    Virtual Reality

    Friday, July 1, 2016 7:54 PM
  • No.

    When I executed following code:

    SELECT 'SQL_Server_Edition' AS 'Verion', SERVERPROPERTY('Edition') AS Type_Of_Edition
    UNION
    SELECT 'Version', @@VERSION

    It get output from below:

    Verion Type_Of_Edition
    SQL_Server_Edition Enterprise Edition: Core-based Licensing (64-bit)
    Version Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) 
    Oct 19 2012 13:38:57 
    Copyright (c) Microsoft Corporation
    Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)


    Virtual Reality

    ok. then do not worry about the code.. as i said, that code is valid only for EVAULATION edition.

    and you are not on that. ignore that message..


    Hope it Helps!!

    Friday, July 1, 2016 8:13 PM
  • Thanks

    Virtual Reality

    Friday, July 1, 2016 8:16 PM