Post reply

SQL 2005 licensing

  • May 14, 2009 at 12:08 pm

    #137827

    I took over a server Production server running SQL 2005 Standard Edition sp3. How can I determine the type of license enabled for this single instance SQL Server?

  • June 26, 2009 at 10:18 pm

    #1016349

    Supposedly, according to Books Online, the following should tell you:

    select serverproperty('LicenseType')

    Problem is when I run it on systems where I know the license mode of the servers I get DISABLED returned. You may just have to see how much was spent acquiring SQL Server to determine.

  • June 26, 2009 at 11:53 pm

    #1016357

    running select serverproperty('LicenseType') on 2005 always returns DISABLED. The only way to keep track of the licence types is to do it manually.

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

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