How to find out number of SQL Server seats purchased?

• yaip

  SSCrazy

  Points: 2656

  More actions

  July 2, 2007 at 11:51 am

  #196599

  How to find out number of SQL Server seats purchased?

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  July 4, 2007 at 12:07 am

  #717060

  If you are using Sql server 2000, then got to CONTROL PANEL, you can see 'SQL server 2000 Licensing setup'. I think it will provide you info reg licensing.

  Regards..Vidhya Sagar
  SQL-Articles

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 4, 2007 at 12:55 am

  #717066

  You can find the information using the query given below.

  select serverproperty('LicenseType') as Type,serverproperty('NumLicenses') as NumberofLicencse

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com