July 4, 2012 at 9:18 am
Hi experts,
How to get info about sql product key which my current sql installation is using in sql server 2008 R2?
regards
Bipan
July 4, 2012 at 9:19 am
USE master
GO
EXEC xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft
SQL Server\80\Registration','CD_KEY'
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 4, 2012 at 9:22 am
I tried this but its not working and my sql server is 2008 R2 so i will be looking in 100 but i m nt able to find registeration item there.
July 5, 2012 at 12:26 pm
Try the key for the instance and the setup. I think I see mine in there. It's MSDN, so hard to tell if that's the right key
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 29, 2014 at 11:18 pm
Try this for SQl Sever 2008 R2 Enterprise
exec xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup\Client_Components_Full','ProductCode'
Ali
MCTS SQL Server2k8
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply