Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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