License Tracking in SQL Server 2005

  • Hi,

    Just wanted to know what everyone thinks of this: Apparently in SQL Server 2005 there is no license tracking, so If I run SELECT SERVERPROPERTY('LICENSETYPE') and then run SELECT SERVERPROPERTY('NUMLICENSES') returns nothing. You have to update the registry with the license information manually so as the above queries return the appropriate information (ie number of processors licensed, amount of client license connections allowed etc).

    Has anyone else run across this at all?? Also I believe this may be the case in SQL 2008 - does anyone know if this is true as well?? If you've seen it, how do you deal with it?

    As always many thanks in advance

    Scott

  • Considering it does not track licensing on its own, I'm not sure what benefit you'll gain. If you have to manually enter it, whether into a table or the registry, I see this as more work than necessary. We have always kept a file (I know, old fashioned) of the licenses purchases so we refer back to that if we have questions about our licensing.

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

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