Solved

How can I tell when SQL 2005 Evaluation period ends?

Posted on 2009-07-15
5
190 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

786 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