Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Evaluation Copy? Expand / Collapse
Author
Message
Posted Wednesday, September 1, 2010 2:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 11, 2011 12:18 PM
Points: 121, Visits: 334
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.
Post #979148
Posted Wednesday, September 1, 2010 3:00 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 3,132, Visits: 11,429
select @@version
Post #979164
Posted Friday, September 3, 2010 8:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 11:40 AM
Points: 1,093, Visits: 2,615
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
Post #980262
Posted Friday, September 3, 2010 10:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:35 AM
Points: 33,102, Visits: 15,213
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #980354
Posted Friday, September 3, 2010 10:55 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:46 PM
Points: 21,351, Visits: 15,028
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #980358
Posted Friday, September 3, 2010 12:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 11:40 AM
Points: 1,093, Visits: 2,615
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


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




_______________________________________________________________________
For better assistance in answering your questions, click here
Post #980431
Posted Friday, September 3, 2010 12:25 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 1,194, Visits: 2,213
Steve is absolutely right.

Thanks & Regards,
SQLBuddy
Post #980442
Posted Tuesday, September 7, 2010 8:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 11, 2011 12:18 PM
Points: 121, Visits: 334
Thanks to everyone for taking the time to respond.
Post #981635
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse