Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
possible duplicate of Can you help me with my software licensing issue? –  Tim Brigham May 9 '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 9 '12 at 16:16
    
Its not a licensing issue really. –  DanBig May 9 '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. –  RobM May 9 '12 at 16:47
add comment

1 Answer

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.

share|improve this answer
    
Thank you, I was able to get my answer from this. –  Matt May 9 '12 at 17:27
    
Please accept the answer if it was what you needed. Thanks. :) –  DanBig May 9 '12 at 17:34
add comment

Your Answer

 
discard

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.