2

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

Matt
  • 21
  • 1
  • possible duplicate of [Can you help me with my software licensing issue?](http://serverfault.com/questions/215405/can-you-help-me-with-my-software-licensing-issue) – Tim Brigham May 09 '12 at 16:14
  • This is going to get closed as a licensing issue. It might be a better fit for dba.stackexchange.com, but check their FAQ first. – wfaulk May 09 '12 at 16:16
  • Its not a licensing issue really. – DanBig May 09 '12 at 16:16
  • 2
    This is not a dupe. The s/w licencing question you reference is for *legal* issues with licences, not how to carry out licence related sysadmin tasks. – Rob Moir May 09 '12 at 16:47

1 Answers1

3
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.

DanBig
  • 11,393
  • 1
  • 28
  • 53