How do I determine the current licensing of a server?

  • Is there a way for me to determine what kind of licensing a current server is set up for?  Is their a stored procedure that can tell me if it's a processor license or CALS and how many?

    These are all existing servers, there has to be a method other than calling accounting.

    thanks in advance for the replys.

     

     

  • How about this:

    SELECT SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses')

    Details on the SERVERPROPERTY function can be found in BOL.

    --Andrew

  • Thank you so much.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply