<?xml version="1.0" encoding="utf-8" ?> <codesnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> <codesnippet format="1.0.0"> <header> <title>Retrieving List of SQL Servers on a Network via SQL-DMO</title> <shortcut>sqldmogetsqlservers</shortcut> <description>Illustrates how to retrieve a list of SQL Server instances found on a local area network.</description> <author>C# .Net Fun - http://www.dotnetfun.com - Michael G.</author> </header> <snippet> <code language="CSharp"> <![CDATA[ // NOTE: This code snippet is designed for VS.NET 2005 or later. // Add a reference to the SQLDMO.DLL file; // usually located in <SQLServerInstallDrive>:\Program Files\Microsoft SQL Server\<Version>\Tools\Binn SQLDMO.ApplicationClass app = new SQLDMO.ApplicationClass(); try { SQLDMO.NameList names = app.ListAvailableSQLServers(); foreach (String strServer in names) { // do something the names here ... } } catch (Exception err) { // SQL-DMO Error... } finally { app.Quit(); app = null; } ]> </code> </snippet> </codesnippet> </codesnippets>