Evaluation Copy?

Question

Post reply

Evaluation Copy?

coenzyme77

SSCommitted

Points: 1669
More actions
September 1, 2010 at 2:30 pm

#228522

Is there a location somewhere in a 2005 SQL Server instance where it is indicated if the instance is running under a licensed or evaluation copy? Thanks for everyone there to help.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 1

Michael Valentine Jones

SSC Guru

Points: 64818

September 1, 2010 at 3:00 pm

#1215301

select @@version

Richard M. SSCertifiable Points: 7401 More actions · Answer 2

Michael Valentine Jones (9/1/2010)
select @@version

That will only provide you with the Version/Edition of the running SQL instance. As of SQL 2005 the licensing info is no longer stored anywhere as it was up to SQL 2000. All you need now is the required paperwork from Microsoft that proves you have the required License. In other words, if you are audited, you need to produce the license info for each 2005+ SQL server installation.

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 3

IF it's eval edition, you can get info here: http://mangalpardeshi.blogspot.com/2009/05/expiration-date-of-sql-server.html

If you want to query each server, I'd think that eval edition had a note in the @@version that it was the version installed. It's also probably in the registry somewhere.

Serverproperty is supposed to return this: http://msdn.microsoft.com/en-us/library/ms174396%28SQL.90%29.aspx%5B/url%5D

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

I would rely on the Serverproperty function. It will return the various editions (standard, enterprise, eval)

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Richard M. SSCertifiable Points: 7401 More actions · Answer 5

Steve Jones - Editor (9/3/2010)
IF it's eval edition, you can get info here: http://mangalpardeshi.blogspot.com/2009/05/expiration-date-of-sql-server.html
If you want to query each server, I'd think that eval edition had a note in the @@version that it was the version installed. It's also probably in the registry somewhere.
Serverproperty is supposed to return this: http://msdn.microsoft.com/en-us/library/ms174396%28SQL.90%29.aspx%5B/url%5D

'teresting... Didn't know there was a Enterprise Evaluation Edition ....

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]