Unique information about SQL server installation

• Matjaz Justin

  Mr or Mrs. 500

  Points: 598

  More actions

  March 10, 2009 at 7:37 am

  #131599

  Where can I find unique information about SQL server installation?

  For SQL 2000 is propagated a solution like this:

  USE master

  EXEC xp_regread 'HKEY_LOCAL_MACHINE',

  'SOFTWARE\Microsoft\Microsoft SQL

  Server\80\registration', 'CD_KEY'

  But what about SQL 2005 and SQL 2008?

  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\ProductID ProductIDNNNNN?

• Mike - CI

  SSCarpal Tunnel

  Points: 4146

  More actions

  March 10, 2009 at 8:08 am

  #956803

  It looks like you have the correct path for 2005.

  I am just guessing but it looks like for 2008 it is

  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup\ProductID