Problem :-
Sometimes it may require to determine all the available instance of SQL Server in network.
Solution:-
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 !!!
RJ
