How to tell version difference between 2000 Enterprise vs. Standard

I have kind of an urgent need here. I need to know if there is a dll file or registry key or something of that nature that I can query on to find out if my SQL 2000 installations are Enterprise or Standard.

I understand I can do this using query analyser, but that will not work with my reporting tool (this is for reporting numbers of SQL installations in our very large enterprise for Microsoft license compliance).

Thanks for any guidance!!

Cheryl Marland

cheryl.marland@.va.gov

In SQL 2000 that information is not written to the registry in a readable format.

If you can't run osql in the discovery process, you could create a windows batch file that's scheduled to run every night at midnight - the batch job could run

select convert(char(20), serverproperty('edition'))
go

and dump the results to an output file. If you can't read the file you could author the script to update a reg key with the information so you're reporting process could pick it up.

Cheers,
Dan

|||

Dan,

Is this info more readily available in SQL 2005?