/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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