views:

1097

answers:

2

I need to get the cd key of my installed instance of SQL Server 2005. I've used the following code and it doesn't work, most likely because I think it was for SQL Server 2000. Please help.

USE master
USE master
EXEC xp_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\Microsoft SQL Server\80\registration',
'CD_KEY'
A: 

I believe that there is no simple unencrypted equivalent of this for later versions of SQL Server.

However, there are various third party tools which claim to be able to retrieve this, such as:

http://www.nirsoft.net/utils/product_cd_key_viewer.html http://www.product-key.com/keyfinders/sql-server-cd-key.htm

Rob Levine
A: 

We bought a product that retrieves cd keys.

DForck42