usingSystem;

usingSystem.Data.Sql;

usingSystem.Text;

namespaceAllSqlServer

{

classProgram

{

staticvoidMain(string[]args)

{

//SQLDMO.NameListnames;

//SQLDMO.ApplicationClassac=newSQLDMO.ApplicationClass();

//names=ac.ListAvailableSQLServers();

//string[]serverList=newstring[names.Count];

//for(inti=0;i<serverList.Length;i++)

//{

//serverList[i]=names.Item(i);

//}

//foreach(stringstrinserverList)

//{

//Console.WriteLine(str);

//}

SqlDataSourceEnumeratorinstance=SqlDataSourceEnumerator.Instance;

System.Data.DataTabletable=instance.GetDataSources();

DisplayData(table);

Console.ReadLine();

}

privatestaticvoidDisplayData(System.Data.DataTabletable)

{

foreach(System.Data.DataRowrowintable.Rows)

{

Console.WriteLine("服务器名={0}",row["ServerName"]);

Console.WriteLine("实例名={0}",row["InstanceName"]);

Console.WriteLine("是否集成验证={0}",row["IsClustered"]);//即Windows身份验证和SQLServer验证

Console.WriteLine("版本={0}",row["Version"]);//8.*是SQL2000,9.*是SQL2005

Console.WriteLine("============================");

}

}

}

}

文章引用自：