Simon Fox
Simon Fox

Reputation: 10591

Enumerate available SQL Servers from .Net

Anyone know if there is a more "up to date" way of enumerating all available SQL Server instances via .Net, i.e. without using System.Data - DataTable/DataRow bits.

SqlDataSourceEnumerator sqlEnumerator = SqlDataSourceEnumerator.Instance;
DataTable dt = sqlEnumerator.GetDataSources();
foreach(DataRow row in dt.Rows)
{
    Console.WriteLine(row["ServerName"]);
    Console.WriteLine(row["InstanceName"]);
    Console.WriteLine("*******************************");
}

Upvotes: 2

Views: 291

Answers (1)

Restuta
Restuta

Reputation: 5903

You can find several answers here.

Upvotes: 3

Related Questions