Retrieve all the installed SQL server istances

Dear every body
i want to retrieve all the installed sql server instances includes the loaca instances
i write this block of code

Code Snippet

Dim lst As Sql.SqlDataSourceEnumerator
lst = Sql.SqlDataSourceEnumerator.Instance
Dim dt As DataTable = lst.GetDataSources
cmbServerLst.Items.Clear()
For Each row In dt.Rows

If row("InstanceName").ToString() = "" Then
cmbServerLst.Items.Add(row("ServerName").ToString())
Else
cmbServerLst.Items.Add(row("ServerName").ToString() + "\" + row("InstanceName").ToString())
End If

this retrieve insatnces in the network but not included the instances installed on my machine
can any help me to know how to retrieve also the local installed instances
(f)

Retrieve all the installed SQL server istances

You can use google to search for other answers

More Threads