Identifying a License Mode

• cnichol4

  SSC Veteran

  Points: 276

  More actions

  September 9, 2003 at 7:31 am

  #63349

  Hi,

  Is there a way to identify the chosen license mode on a given instance of SQL Server.

  Thanks for the help.

  Charles L. Nichols

  
  Charles L. Nichols

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  September 9, 2003 at 7:42 am

  #473209

  Contro panel --> SQL Server 2000 license.

  Edited by - allen_cui on 09/09/2003 07:42:43 AM

• philcart

  SSC-Forever

  Points: 47796

  More actions

  September 9, 2003 at 5:37 pm

  #473334

  You can also do

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

  Check out SERVERPROPERTY in BOL for a number of other properties that you can see.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface