Good Day,

Can the Kbox show me which computers have SQL Standard edition and which have Enterprise edition on (this is for SQL 2005 and 2008)?

Thank you.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
To the best of my knowledge Microsoft doesn't actually differentiate those other than licensing; meaning that the installations look similar (if not Identical) on installation. The express editions look different and KBOX easily detects them differently. That being said, if there's a difference in the registry or file stucture between Standard, Enterprise, and any other flavors, you could certainly create a custom inventory rule. In the infamous words of my favorite Star Trek quote "the thing's gotta have a tailpipe"- translated- we can figure it out. :)
Answered 09/20/2010 by: cblake
Red Belt

Please log in to comment
0
It looks like you can do this by using a batch file to call a SQL statement to get the version:

http://www.dostips.com/DtCodeBatchFiles.php#Interfacing.Sql2
http://www.aspfaq.com/sql2005/show.asp?id=20
http://blog.flimatech.com/?p=1302

But like cblake said, if you find a registry entry or file that is different, a custom inventory rule would be simpler.
Answered 09/21/2010 by: jknox
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity