I have seen many people on here trying to make a report that tells them what edition of MS SQL Server they have as the current report doesnt show this.

Here is what I did to sort this out (with help from EPIServer's post a couple of years ago)

I added the registery key into registry scanner and scanned for SQL 2005 & 2008

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\Setup Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\Microsoft SQL Server 10 DisplayName
HKEY_LOCAL_MACHINE\ SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\Microsoft SQL Server 2005 DisplayName

The user EPIServer then created another object called [0sqlversions2] but I had problems with this and avoided that and have done the following:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblRegistry1.Value As Product, tblRegistry.Value As Edition, tblRegistry.Lastchanged From tblComputers Inner Join tblRegistry On tblComputers.Computername = tblRegistry.Computername Inner Join tblRegistry tblRegistry1 On tblComputers.Computername = tblRegistry1.Computername Where tblRegistry.Regkey Like '%sql%' And tblRegistry1.Valuename = 'DisplayName' And tblRegistry.Valuename = 'Edition' And tblRegistry1.Regkey Like '%sql%'



I hope this helps someone.

RagingBull

Hi,

In ur registry it is showing only SQL 2005 or above also can be shown?we are using SQL 2008 R2..while adding the registry what is the value we need to put?

What is the value i need to add..because it is asking..