Microsoft SQL Server: Determining CD Key
Contributed by Rob Rogers 
Tagged: Database You can easily determine your CD key for your SQL Server software by just typing a few lines into the query window. To do this:
1. Open up the query window.
2. Copy and paste the following:
USE master
USE master
EXEC xp_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\Microsoft SQL Server\80\registration',
'CD_KEY'
3. Execute the query.
The results will give you the CD key under the Data column.
You may also like -
Microsoft SQL Server: Determine MDAC Version
SQL Server 2005: What Service Pack is Installed?
SQL Server 2005: Include Column Headers When Copying Grid Query Results
SQL Server 2005: How to Reset a Forgotten Password for the sa Account
SQL Server 2005: Return a Comma Delimited Result Set from Queries
SQL Server 2005: How To Enable xp_cmdshell
SQL Server 2008/2008 R2: Move tempdb to Improve Performance
SQL Server 2005: Easily Grant Select to All Tables and/or Views in a Database
angad said on February 18, 2009
Product key for registration of SQL server 2005
Muralikrishna said on August 3, 2010
USE master
USE master
EXEC xp_regread ‘HKEY_LOCAL_MACHINE’,
‘SOFTWAREMicrosoftMicrosoft SQL Server80registration’,
‘CD_KEY’
Bijendra said on November 18, 2010
hi all masters ,
i m a student, got a sql server 2005 edition. But there is no product key.
Please provide me the key or any way how to get it ?