query licensing information

  • Is there a way to query licensing info for a server?

    thanks

  • Think you can use this query to get what you need.

    select SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses')

    Thanks!

  • great - that worked for 2000.  In 2005 it shows 'disabled',null respectively.  Other properties, such as edition work though.

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

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