Alexander Gladchenko

-- BOL Versions (2007/06/06)
USE master
GO
DECLARE @key nvarchar(256), 
	@ProductName nvarchar(256), 
	@Version  nvarchar(256), 
	@Language nvarchar(4)

-- 9.0000.7028.1803 
-- Microsoft SQL Server 2005 Books Online (English) (February 2007) 
-- 9.00.3062
EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\20959DF9723754C4682C71589F87E578',
	@value_name='ProductName',
	@value=@ProductName OUTPUT

EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\20959DF9723754C4682C71589F87E578',
	@value_name='Language',
	@value=@Language OUTPUT
SET	@key = 'SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\BOL\' + 
	CASE CAST (@Language AS varbinary)
		  WHEN 0x0900040000000000 THEN '1033\CurrentVersion'
		  WHEN 0x1900040000000000 THEN '1049\CurrentVersion'
	END
EXECUTE master..xp_regread 
	@rootkey='HKEY_LOCAL_MACHINE',
	@key=@key,
	@value_name='Version',
	@value=@Version OUTPUT

IF	@ProductName IS NOT NULL
SELECT	@ProductName AS [Product Name], 
	ISNULL(@Version, 'N/A') AS [Version]
SELECT	@ProductName = NULL, @Version = NULL, @Language = NULL, @key = NULL

-- 9.0000.7103.1540 
-- Электронная документация по Microsoft SQL Server 2005 (на русском языке) (февраль 2007)
-- 9.00.3068
EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\4685610755BF4B545BCFFB44AED0BDEB',
	@value_name='ProductName',
	@value=@ProductName OUTPUT
EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\4685610755BF4B545BCFFB44AED0BDEB',
	@value_name='Language',
	@value=@Language OUTPUT
SET	@key = 'SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\BOL\' + 
	CASE CAST (@Language AS varbinary)
	WHEN 0x0900040000000000 THEN '1033\CurrentVersion'
	WHEN 0x1900040000000000 THEN '1049\CurrentVersion'
	END
EXECUTE master..xp_regread 
	@rootkey='HKEY_LOCAL_MACHINE',
	@key=@key,
	@value_name='Version',
	@value=@Version OUTPUT

IF	@ProductName IS NOT NULL
SELECT	@ProductName AS [Product Name], 
	@Version AS [Version]
SELECT	@ProductName = NULL, @Version = NULL, @Language = NULL, @key = NULL

-- 9.0000.6089.0206
-- Microsoft SQL Server 2005 Books Online (English)
-- 9.00.1399.06
EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\447A34B08B1B9804B91DD9147CCEA03A',
	@value_name='ProductName',
	@value=@ProductName OUTPUT
EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\447A34B08B1B9804B91DD9147CCEA03A',
	@value_name='Language',
	@value=@Language OUTPUT
SET	@key = 'SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\BOL\' + 
	CASE CAST (@Language AS varbinary)
    	  WHEN 0x0900040000000000 THEN '1033\CurrentVersion'
    	  WHEN 0x1900040000000000 THEN '1049\CurrentVersion'
	END
EXECUTE master..xp_regread 
	@rootkey='HKEY_LOCAL_MACHINE',
	@key=@key,
	@value_name='Version',
	@value=@Version OUTPUT

IF	@ProductName IS NOT NULL
SELECT	@ProductName AS [Product Name], 
	@Version AS [Version]
SELECT	@ProductName = NULL, @Version = NULL, @Language = NULL, @key = NULL

-- 9.0000.7138.2105
-- Microsoft SQL Server 2005 Books Online (English) (May 2007)
-- 9.00.3070
EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\706CF427A4AA23F4CAD1887BDE6AAC58',
	@value_name='ProductName',
	@value=@ProductName OUTPUT
EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\706CF427A4AA23F4CAD1887BDE6AAC58',
	@value_name='Language',
	@value=@Language OUTPUT
SET	@key = 'SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\BOL\' + 
	CASE CAST (@Language AS varbinary)
    	  WHEN 0x0900040000000000 THEN '1033\CurrentVersion'
    	  WHEN 0x1900040000000000 THEN '1049\CurrentVersion'
	END
EXECUTE master..xp_regread 
	@rootkey='HKEY_LOCAL_MACHINE',
	@key=@key,
	@value_name='Version',
	@value=@Version OUTPUT

IF	@ProductName IS NOT NULL
SELECT	@ProductName AS [Product Name], 
	@Version AS [Version]
SELECT	@ProductName = NULL, @Version = NULL, @Language = NULL, @key = NULL

-- 10.0000.7116.0234
-- Microsoft SQL Server "Katmai" Books Online
-- 10.0.1019.17
EXECUTE master..xp_regread	
	@rootkey='HKEY_CLASSES_ROOT',
	@key='Installer\Products\E6A80054E319FF94F807C23955CDAB56',
	@value_name='ProductName',
	@value=@ProductName OUTPUT

EXECUTE master..xp_regread 
	@rootkey='HKEY_LOCAL_MACHINE',
	@key='SOFTWARE\Microsoft\Microsoft SQL Server Code Name Katmai Redist\BOL\1033\CurrentVersion',
	@value_name='Version',
	@value=@Version OUTPUT

IF	@ProductName IS NOT NULL
SELECT	@ProductName AS [Product Name], 
	@Version AS [Version]
SELECT	@ProductName = NULL, @Version = NULL, @Language = NULL, @key = NULL
GO