SQL 2008 Find out what licensing it is using.

Question

How can I tell the licensing that is setup on a production SQL server?

Answer 1

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

PER_SEAT = Per-seat mode

PER_PROCESSOR = Per-processor mode

DISABLED = Licensing is disabled.