Home             About Us             Sign Guest Book             Contact Us             Subscribe              RSS  
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
Articles
Code Snippets
Links
FAQ
Resources

Saravana Kumar
Vinod Kumar

Click on the image to subscribe to our Monthly Newsletter.


Click here for Archives

No Chats Available

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.

 

Comment about this article
Free Hit Counters
Free Hit Counters