SQL Server Licensing

[Martyn.Jones.Uk]

How does one find out what type of licensing is employed on a SQL
Server Box. i.e is it Per Process or Per CAL?

Martyn

[David Portas]

SELECT SERVERPROPERTY('LicenseType')

--
David Portas
SQL Server MVP
--

[Mark D Powell]

David, do you know what it means if the query returns "DISABLED" ?

-- Mark D Powell --

[David Portas]

Either you've got Developer Edition (Check SELECT
SERVERPROPERTY('Edition') to find out) or it's been installed from the
MSDN disk set. Both are for non-production use and so don't implement
the licence model setting.

--
David Portas
SQL Server MVP
--

[Stu]

It means that Bill Gates will be knocking on your door at any minute :)
(Thank you, I'll be here all week. Try the veal.)

From the Books OnLine:

LicenseType Mode of this instance of SQL Server.
PER_SEAT = Per-seat mode
PER_PROCESSOR = Per-processor mode
DISABLED = Licensing is disabled.

It may be because the applet is disabled in Windows Server 2003 by
default: http://support.microsoft.com/default...b;en-us;824196

[Mark D Powell]

The response for the query was "Standard Edition".

Thank you for the response.

-- Mark D Powell --

[Mark D Powell]

Stu, thank you for the link. It would seem that disabled is the
expected value.

-- Mark D Powell --