Determine all SQL SERVER instance in entire network or at least your machine :) TIP #41


Problem :-

Sometimes it may require to determine all the available instance of SQL Server in network.


One of the easy way to determine the instance with SQLCMD.

Lets understand this by following steps

1) Open dos prompt

2) write SQLCMD – L   OR SQLCMD/L

Above command with return instance on your machine as well on network

See below screen snap for detail


Enjoy !!!


Leave a Reply

Your email address will not be published. Required fields are marked *