Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I determine the version of SQL 2005 Server on a machine.

I need to know if it is a Server license or a Processor license.

I've found

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

which returns:


Also found this:

But is altering the registry the only way?

share|improve this question
up vote 3 down vote accepted

Keep in mind that if you installed SQL Server via a Volume License Agreement it will show as DISABLED NULL when you run the query that you posted.

Our SQL Server (which is legit and installed via a volume license agreement) doesn't return license information as the volume license installer doesn't ask for license information.

Your most reliable way to check on licenses is to find the paperwork from when it was purchased.

share|improve this answer

Sql Server no longer tracks licensing - if you want to enable it you can modify the registry (unconfirmed)- see this Microsoft Blog post

share|improve this answer

This indicates that licensing is disabled on your server. Perhaps it's SQL Express or SQL Developer edition, neither of which have licensing requirements in the sense of Per Seat / Per Processor licensing.

Here is the MSDN reference page for SERVERPROPERTY() for SQL 2005 that lists all of the possibilities.

share|improve this answer
That documentation is incorrect, as the LicenseType and NumLicenses server properties are useless ever since SQL Server 2005:… – Michel de Ruiter Mar 15 at 11:04

Check your edition as well. For Developer edition, the LicenseType will return 'disabled'

select serverproperty('LicenseType'), 
share|improve this answer

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.