Raghavender (9/14/2011)

---

I think below will give the expected result:

-- Create Temporary table to store the data
Create Table #SQLInstances
( Value nvarchar(100),
InstanceName nvarchar(100),
Data nvarchar(100))

-- Read Data from Registery
Insert into #SQLInstances
EXECUTE xp_regread
@rootkey = 'HKEY_LOCAL_MACHINE',
@key = 'SOFTWARE\Microsoft\Microsoft SQL Server',
@value_name = 'InstalledInstances'

Select InstanceName from #SQLInstances

Raghavender (9/13/2011)

---

Hi All,

How to find out Installed SQL Server Instances and their names on a server using T-SQL or any other way ?

crazy4sql (9/14/2011)

---

The easiest way for me is, go to services and check the sql server services.
If its named instance then your sql service will be named as mssql$instancename, if its default instance then simply mssqlserver.

I think this becomes bit difficult if we have 100 instances or more ..

Thank You,

Best Regards,
SQLBuddy

crazy4sql (9/14/2011)

---

100 instance in one server. tell me your server name and I am going to report it to MS