Sql Server 2005 Evaluation, how to find how much time is left

Posted on 2006-05-16
Last Modified: 2008-01-09
I have Sql Server 2005 Evaluation 180 days, how can I find how many days are left before the evaluation period expires? I have tried both with SELECT @@version and xp_msver but that information isn't shown...
Question by:cip
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    I don't know the "correct" answer, but I would look at the creation time of the folders of sql server, add 180 days to that and, well, you know the rest...
    LVL 39

    Expert Comment

    in t/sql try
    select @@version

    not sure if it gives the days left information or not, i dont have evaluation version cant check it here.
    LVL 39

    Expert Comment

    LVL 28

    Expert Comment

    may be this will help

    select datediff(dd,getdate(),dateadd(dd,180,min(crdate))) as daysleft from sysdatabases where status = 16
    LVL 1

    Author Comment

    I think imran_fast is close to it, none of the other properties/stored procedures shows that info as well.

    Let me make it clearer, your query computes the difference between date Sql server instance has been created + 180 days and today right?
    LVL 28

    Accepted Solution

    Yes ,

    Actually it is the difference of  date when first database is created on the server and today's date.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now