EnumSQLSvr  

Home
Up
What's New
DTS
SQL-DMO
SQL-NS
XP's
SQL Agent
Events
FAQ
Links
About...

 

EnumSQLSvr.exe - Enumerate SQL Servers

version: 1.0x002

last updated: 27 January 2003

platform: SQL Server 2000 running Windows NT 4.0 and higher

Description:

Enumerate SQL Servers in a domain using the LAN Manager API NetServerEnum().

 

See also: ListSQLSvr - Enumerate SQL Servers on the network using ODBC SQLBrowseConnect

Usage:

EnumSQLSvr.exe version 1.0x2

EnumSQLSvr usage:

-D Enumerate SQL Servers in specified domain (default is primary domain)
-X Extended info
-V Verbose mode
-? This help screen

sample usage:
EnumSQLSvr <CR>
Lists all SQL Server instances in primary domain
EnumSQLSvr -D MyDomain <CR>
Lists all SQL Server instances in domain: MyDomain
 

Sample output:

First example lists the SQL Servers in your current domain

EnumSQLSvr <CR>
ASTERIX
IDEFIX
OBELIX
Total entries fetched 3


Second example lists the SQL Servers in your current domain with extended information (if available)

EnumSQLSvr -X <CR>
name:c     ASTERIX
comment:   GertD@SQLDev.Net development machine
OS version 5.1
name:      IDEFIX
comment:
OS version 5.2
name:      OBELIX
comment:
OS version 5.0
Total entries fetched 3

Third example lists the SQL Servers in a specified domain with extended information (if available)

EnumSQLSvr -X -D SQLDEV <CR>
name:c     ASTERIX
comment:   GertD@SQLDev.Net development machine
OS version 5.1
name:      IDEFIX
comment:
OS version 5.2
name:      OBELIX
comment:
OS version 5.0
Total entries fetched 3

Installation:

Simply copy EnumSQLSvr.exe onto your machine.

Download EnumSQLSvr.zip

Download EnumSQLSvr-src.zip (Visual C++ 7.0 project)

Requirements:

Windows NT 4.0 or higher.

Planned functionality enhancements:

  • None
     

  • Other suggestions, ideas, please send email to ideas

***

Questions or problems regarding this web site should be directed to webmaster@sqldev.net.
Copyright © 1991-2003 SQLDev.Net. All rights reserved.
Last modified: 07/06/03.