Home Forums SQL Server 2008 SQL Server 2008 Administration NO. of instances RE: NO. of instances

  • April 23, 2013 at 9:40 am

    #1609141

    ok by looking at a different registry key and looking for Service names, i think this finds them all on my sample machine:

    /*

    ResultsId ResultsText

    233 MSSQL$SQL2005

    234 MSSQL$SQL2008R2

    235 MSSQL$SQL2012

    237 MSSQLSERVER

    */

    declare @Results TABLE (ResultsId int identity(1,1) not null primary key,

    ResultsText varchar(200) )

    insert into @Results(ResultsText)

    EXECUTE master..xp_regenumkeys 'HKEY_LOCAL_MACHINE' , 'SYSTEM\CURRENTCONTROLSET\SERVICES\'

    select * from @Results

    WHERE ResultsText = 'MSSQLSERVER'

    OR ResultsText LIKE 'MSSQL$%'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!