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.
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)
Please log in to answer
Posted by:
cblake
14 years ago
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
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.
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.
so that the conversation will remain readable.