Changing SQL Licensing

This article is about changing the licencing mode of SQL Server 2000 from per processor licence to per seat licence. Is it at all possible. This method is not documented in SQL Server 2000.

To change SQL Server licensing you go to control panel and one of the licensing mode is greyed out and you are only able to add either devices if it is per seat or processor if the licensing is per processor.

To change the licensing mode from one type to another you can do the following. Do this at your own risk as it involves changing the registry key.
In the registry Navigate to: Hkey_Local_Machine\Software\Microsoft\Microsoft
SQL Server\80 \MSSQLLicenseInfo\MSSQL8.00\Mode

Change the mode to
- 0 if you want per seat licence
- 1 if you want to use control panel to change the licencing mode
- 2 if you want per processor licence

I have applied this changes to development environment and it hasn't affected anything.