SQLCMD

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. 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 …