DavidJ-Zonal
asked on
Finding SQL Servers on a network
Hello,
Does anybody know of a way of returning a list of all SQL Servers on the local network? I need to be able to give the user a drop down list, similar to the one in the SQL Server Registration box in Enterprise Manager.
Any clues?
Cheers,
Does anybody know of a way of returning a list of all SQL Servers on the local network? I need to be able to give the user a drop down list, similar to the one in the SQL Server Registration box in Enterprise Manager.
Any clues?
Cheers,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fantastic- Just what I needed...
Cheers.
Cheers.
Use the function NetServerEnum. It does exactly what you want.
Sincerely,
Nestorua.