/build/static/layout/Breadcrumb_cap_w.png

SQL Standard VS Enterprise

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

Answers (2)

Posted by: cblake 14 years ago
Red Belt
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. :)
Posted by: jknox 14 years ago
Red Belt
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ