Enterprise or Standard

  • How do I tell by using EM, QA or other tool which edition of SQL is running on a server Standard or Enterprise? And is there a way to tell what type of license it was installed with, Server, Per Seat, Per Processor?



    - Vega

  • Try select SERVERPROPERTY ('edition') for the edition, select SERVERPROPERTY ('numlicenses') to get the licenses, and select SERVERPROPERTY ('licensetype') for the license type.

    Andy

  • Perfect, Thank-you!



    - Vega

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

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