How to verify installed license

I have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals.

Thanks,

Skip Berry

Hi,

SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType'))
SELECT CONVERT(char(20), SERVERPROPERTY('NumLicenses'))

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Don't know if you had better luck with that... but with the patches I've been using, I still get Disabled and NULL for license information.

Following this http://support.microsoft.com/default.aspx?scid=kb;en-us;291332 however, does correctly direct me to the SQL 2000 Licensing Setup applet in control panel, which WILL display what is currently being used.

(Now, all my instances are running on the default instance... not certain what you will get back if you have something other than the default instance.)

|||Which version are you using, Developer or any MSDN version ?

Jens K. Suessmeyer

http://www.sqlserver2005.desql