Solved

How can I tell when SQL 2005 Evaluation period ends?

Posted on 2009-07-15
5
191 Views
Last Modified: 2012-05-07
How can I tell when SQL 2005 Evaluation period ends?
0
Comment
Question by:mattkovo
  • 3
5 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24866254
generally evaluation period is for 180 days and when it ends, you will not be able to use it. I don't understand your question clearly
0
 
LVL 26

Accepted Solution

by:
tigin44 earned 500 total points
ID: 24866283

the following query will give you the results.

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

it gives the difference of  date when first database is created on the server and today's date.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24866310
Just try any of the methods here

1. Open SSMS --> Help --> About.
2. Just go through the Bootstrap log in the path
%WINDIR%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\

This will contain the Installation date and hence you would be able to find it out.
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24866328
run following query, find system database createdate so that you will came to know how old your db is and how many days left

select * from sysdatabases
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24866339
well, one more way, in program file-> microsoft sql server check create date of data folder by right click and property, it will also tell you how old installation is.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 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