• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

How can I tell when SQL 2005 Evaluation period ends?

How can I tell when SQL 2005 Evaluation period ends?
0
mattkovo
Asked:
mattkovo
  • 3
1 Solution
 
RiteshShahCommented:
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
 
tigin44Commented:

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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
RiteshShahCommented:
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
 
RiteshShahCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now