Home About Us SQL Interview Book Contact Us RSS
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
Articles
Code Snippets
Links
FAQ
Resources

Saravana Kumar
Vinod Kumar


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.