How to view SQL Server licenses

Question

I understand that there are three kinds of SQL licenses: http://www.microsoft.com/sqlserver/2005/en/us/pricing-licensing-faq.aspx

Is there a a dialog in SSMS, a sproc, registry key, etc I can look at on a server to determine the type and number of licenses?

Thanks

Answer 1

Found this entry, which recommends to run this, in Query Analyzer:

select serverproperty('LicenseType'),serverproperty('NumLicenses')

"If the above query returns DISABLED then locate this "sqlslic.cpl" file in SQL server folder(C:\Program Files\Microsoft SQL Server\80\Tools\Binn), Right Click-> Open with Control Panel. this will show you the licensing type used"

Also:

"DISABLED usually means you are using an MSDN copy of SQL Server (so, not a production license - MSDN licenses are meant for development and testing)."