Home Forums SQL Server 2005 Business Intelligence How to check Edition of Analysis Services, version and edition of Reporting Services RE: How to check Edition of Analysis Services, version and edition of Reporting Services

  • 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.



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare