September 18, 2008 at 12:12 pm
First, let me start off by saying I am completely new to anything related to SQL so I apoligize in advance for my ignorance but I need some expert advice. I have been tasked to find out if there is a way to identify what uniquely defines each specific version of SQL software to be tracked and counted. For example. The executable for SQL Standard may be a specific size or there may be a registry key with the version build number?? I am dealing with SQL Server 2000 and SQL Server 2005, the problem is I cant tell from my discovery agent whether it is Standard, Enterprise, Etc. Can anyone help with this matter? Basically i need to configure the agent to search for a specific size or build number of SQL but don't know any way of getting this information without logging into every box and querying it...............very time consuming since we are dealing with over 2000 servers. Help!
September 18, 2008 at 12:21 pm
Unfortunately, the build numbers do not distinguish the different editions of SQL Server.
😎
September 18, 2008 at 12:28 pm
You could write something in .NET that enumerates the servers and logs in and gets the edition. It shouldn't take too long to have a simple utility that does that.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply