SQL Server Developer Edition

[jcassidy]

I'm trying to find out how many installations I have of SQL Server Developer Edition at a remote site. I have a script that logs all the exe files on a workstation to a database. From there when I do a search for SQL and all versions and editions of SQL are returned.

I need to know if there is any single utility(exe) available with the Developer Edition that is not installed with the other editions.

 

[Corran007]

Best thing is take a machine you know is developer, and one that you know is not and have it look for difference. Or set up a machine that has developer run your script, uninstall it and install standard or enterpise and run it again and compare differences. but no i do not know of anythign offhand.

 

[sguslan]

Look for difference in the Registry. The version would have to be different. You have to have access to all Windows Registries in all machines in question. You can read registries using many scripting tools like VBScript or Perl .. ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[jcassidy]

First off, thanks for your help folks.

I considered the differences in registry and files, but we have people running all different versions and editions. So far I have found Standard. Personal, Desktop(?), and Developer.

What I did as a work around was find all machines at the site with SQL "Anything" and register them into Enterprise Manager. I then did a properties on the server, which yielded whether it was developer or not. That info has to be coming from somewhere and I suspect the registry. I could not connect to all machines (not on our domain?) which obviously only gave me a partial listing.

I will install the Developer Edition and look for the key that gives the Properies page.

Thanks much to you both for your help.