I'd use SQL-DMO - just add a reference to the COM object "Microsoft
SQLDMO Object Library" (sqldmo.dll) and then you're good to go:

public ArrayList FillListOfServers()
{
    ArrayList alsServers = new ArrayList();
   
    SQLDMO.NameList oNames;
    SQLDMO.Application oSQLApp;

    try
    {
        oSQLApp = new SQLDMO.Application();
        oNames = oSQLApp.ListAvailableSQLServers();

        for (int i = 1; i <= oNames.Count; i++)
        {
            if (!alsServers.Contains(oNames.Item(i)))
            {
                alsServers.Add(oNames.Item(i));
            }
        }
        oNames = null;
        oSQLApp = null;
    }
    catch
    {
        // handle exception
    }
}

SQL-DMO is installed as part of SQL Server, when you install it on
your machine.

Marc

Use DMO and Interop. Once SQL Server 2005 is out, you will be able to use SMO
in .NET, but DMO and Interop is the only way right now. You will have to
create a .NET wrapper to call the DMO classes.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************