Quick and dirty, run this from an SSMS query window (connected to the DB engine):
[font="Courier New"]declare @table1 table (id tinyint identity (1,1), data sysname)
declare @count smallint,
@i smallint,
@key nvarchar(8),
@sql nvarchar(1000)
set @i = 1
insert into @table1 (data)
exec xp_regenumkeys 'HKEY_LOCAL_MACHINE', 'Software\Microsoft\Microsoft SQL Server'
select @count = coalesce(count(*), -1)
from @table1
where upper(data) like 'MSSQL.%'
while @i <= @count
begin
set @key = 'MSSQL.' + cast(@i AS nvarchar(2))
set @sql = 'xp_regread ''HKEY_LOCAL_MACHINE'', ''Software\Microsoft\Microsoft SQL Server\' + @key + '\Setup'', ''Featurelist'''
exec (@sql)
set @sql = 'xp_regread ''HKEY_LOCAL_MACHINE'', ''Software\Microsoft\Microsoft SQL Server\' + @key + '\Setup'', ''Edition'''
exec (@sql)
set @i = @i + 1
end
[/font]
This will return installed features followed by editions for each installed product. NB - assumes stuff is installed as default instance.
Or you could just open regedit & browse to the keys listed above.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare