Post reply

How to check License installation details?

  • December 3, 2003 at 7:35 am

    #65164

    I am trying to complete a licensing audit of SQL Server (2000 SP3) installations. I have gathered all the physical copies of our license documentation.

    Now I would like to match them up to the specific installations. I can get the version and edition information under server properties, but I can't find any way to review if the license installation was configured by processor(s) or CALs.

    Thanks!

  • December 3, 2003 at 11:07 am

    #484490

    Try:

    SELECT SERVERPROPERTY('LicenseType')

  • December 3, 2003 at 12:35 pm

    #484519

    SQL server 2000 licensing setup of control panel

  • December 4, 2003 at 6:56 am

    #484590

    Thanks for the quick replies! Both of these methods work well.

    However, in some cases the T-SQL statement returns a 'Disabled' value. Is there a way to enable licensing without re-installing SQL Server?

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

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