Post reply

To know the Licensingmode

  • March 2, 2009 at 12:22 pm

    #218840

    Hi,

    We have sql server 2000 installed already. How can we know with what licensing mode it was installed?where can check for this?

  • March 2, 2009 at 12:29 pm

    #952043

    Give this a try:

    select serverproperty('LicenseType')

  • March 2, 2009 at 12:50 pm

    #952053

    SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType')); and its showing output as DISABLED.

    What this mean? we have sql server 2000 standard edition with SP4

  • March 2, 2009 at 1:23 pm

    #952071

    Mani (3/2/2009)

    SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType')); and its showing output as DISABLED.

    What this mean? we have sql server 2000 standard edition with SP4

    I don't really know. I get the same thing on our systems and SERVERPROPERTY in BOL doesn't say a whole lot.

  • March 2, 2009 at 1:46 pm

    #952093

    After you install SQL Server, you can use "SQL Server 2000 Licensing" in Control Panel. Double click on it and check that.

    HTH!

    MJ

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

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