Hi Piotrei Stachowicz,
You can use enumeration. There is a good example, i somehow extract it.
public enum ServerType : uint
{
/// <summary>
/// All workstations
/// </summary>
SV_TYPE_WORKSTATION = 0x00000001,
/// <summary>
/// All computers that have the server service running
/// </summary>
SV_TYPE_SERVER = 0x00000002,
/// <summary>
/// Any server running Microsoft SQL Server
/// </summary>
SV_TYPE_SQLSERVER = 0x00000004,
/// <summary>
/// Primary domain controller
/// </summary>
SV_TYPE_DOMAIN_CTRL = 0x00000008,
/// <summary>
/// Backup domain controller
/// </summary>
SV_TYPE_DOMAIN_BAKCTRL = 0x00000010,
/// <summary>
/// Server running the Timesource service
/// </summary>
SV_TYPE_TIME_SOURCE = 0x00000020,
/// <summary>
/// Apple File Protocol servers
/// </summary>
SV_TYPE_AFP = 0x00000040,
/// <summary>
/// Novell servers
/// </summary>
SV_TYPE_NOVELL = 0x00000080,
/// <summary>
/// LAN Manager 2.x domain member
/// </summary>
SV_TYPE_DOMAIN_MEMBER = 0x00000100,
/// <summary>
/// Server sharing print queue
/// </summary>
SV_TYPE_PRINTQ_SERVER = 0x00000200,
/// <summary>
/// Server running dial-in service
/// </summary>
SV_TYPE_DIALIN_SERVER = 0x00000400,
/// <summary>
/// Xenix server
/// </summary>
SV_TYPE_XENIX_SERVER = 0x00000800,
/// <summary>
/// Windows NT workstation or server
/// </summary>
SV_TYPE_NT = 0x00001000,
/// <summary>
/// Server running Windows for Workgroups
/// </summary>
SV_TYPE_WFW = 0x00002000,
/// <summary>
/// Microsoft File and Print for NetWare
/// </summary>
SV_TYPE_SERVER_MFPN = 0x00004000,
/// <summary>
/// Server that is not a domain controller
/// </summary>
SV_TYPE_SERVER_NT = 0x00008000,
/// <summary>
/// Server that can run the browser service
/// </summary>
SV_TYPE_POTENTIAL_BROWSER = 0x00010000,
/// <summary>
/// Server running a browser service as backup
/// </summary>
SV_TYPE_BACKUP_BROWSER = 0x00020000,
/// <summary>
/// Server running the master browser service
/// </summary>
SV_TYPE_MASTER_BROWSER = 0x00040000,
/// <summary>
/// Server running the domain master browser
/// </summary>
SV_TYPE_DOMAIN_MASTER = 0x00080000,
/// <summary>
/// Windows 95 or later
/// </summary>
SV_TYPE_WINDOWS = 0x00400000,
/// <summary>
/// Root of a DFS tree
/// </summary>
SV_TYPE_DFS = 0x00800000,
/// <summary>
/// Terminal Server
/// </summary>
SV_TYPE_TERMINALSERVER = 0x02000000,
/// <summary>
/// Server clusters available in the domain
/// </summary>
SV_TYPE_CLUSTER_NT = 0x01000000,
/// <summary>
/// Cluster virtual servers available in the domain
/// (Not supported for Windows 2000/NT)
/// </summary>
SV_TYPE_CLUSTER_VS_NT = 0x04000000,
/// <summary>
/// IBM DSS (Directory and Security Services) or equivalent
/// </summary>
SV_TYPE_DCE = 0x10000000,
/// <summary>
/// Return list for alternate transport
/// </summary>
SV_TYPE_ALTERNATE_XPORT = 0x20000000,
/// <summary>
/// Return local list only
/// </summary>
SV_TYPE_LOCAL_LIST_ONLY = 0x40000000,
/// <summary>
/// Lists available domains
/// </summary>
SV_TYPE_DOMAIN_ENUM = 0x80000000
}
For more info how to implement it:
http://codeproject.com/csharp/CompPickerLib.asp
Hope it helps you.
--
Regards,
Chua Wen Ching :)
"Piotrek Stachowicz" wrote:
[color=blue]
> Hi,
> I'd like to display list of all MS SQL servers which are available on
> the network
> (I write application which uses database located on one of the machines in
> my LAN). Has anyone got any idea what to do in order to obtain list of all
> such servers?!
>
> When you open Sql Service Manager (for sql server2000) you've got such list.
>
> Thanks,
>
> Piotrek
>
>
>[/color]
