Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I understand that there are three kinds of SQL licenses:

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?


share|improve this question

2 Answers 2

up vote 3 down vote accepted


LicenseType is Unused. License information is not preserved or maintained by the SQL Server product. Always returns DISABLED.

This is true for 2005+, so it does NOT mean that you are using an unlicensed version, contrary to the previous answer.

share|improve this answer
Also, see this:… – VoteCoffee Feb 9 at 20:42

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"


"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)."

share|improve this answer
Thanks! You answered my next questions already! – Booji Boy May 11 '09 at 13:50
I guess this only holds true for SQL Server 2000. SQL Server 2005+ don't maintain this info anymore see answer by VoteCoffee – Booji Boy Feb 9 at 21:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.