Q: How can I list SQL Servers on the network easily ?
Answer:
The basic assumption Iam making is that you have the
SQL Server Client tools installed on your machine. Type the following from the
command prompt:
c:/> osqlw /L
This would list the SQL Servers on the network for
you. You can also achieve this by using DMO and other methods.
This is something I feel is the easiest of all.
This is a handy tip to have in hand. There are other
methods to get the list like the
SQLDMO to list all servers.
But this is the easiest of them all as this does a UDP broadcast and gets all
the server names in the network.
|