Solved

How can I tell when SQL 2005 Evaluation period ends?

Posted on 2009-07-15
5
195 Views
Last Modified: 2012-05-07
How can I tell when SQL 2005 Evaluation period ends?
0
Comment
Question by:mattkovo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

627 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