test.cs

This articles shows how to retrieve a list of PCs on the local network which are running MS SQL Serv

using System;
using Util;

namespace SqlServerTest
{
	/// <summary>
	/// Summary description for Class1.
	/// </summary>
	class Class1
	{
		/// <summary>
		/// The main entry point for the application.
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
            SqlServerInfo[] servs = SqlServerInfo.Seek();
            foreach(SqlServerInfo serv in servs)
            {
                Console.WriteLine(serv);

                // For this to display the Catalogs,
                // You must be able to connect using 
                // Integrated (Windows) Security.
                // If not, fill in the following lines:
                // serv.UserId = "......";
                // serv.Password = ".....";
                foreach(string catalog in serv.Catalogs)
                {
                    Console.WriteLine("\t{0}", catalog);
                }
            }

        }
	}
}