Hello friends, Many times it happened with me I forgot the instance name of SQL Server. So here is a small trick which will help you in determining the entire running SQL Server instance on your machine. You just need to run a simple command on Command prompt. C:>SQLcmd -L This simple command will provide …
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 …