How to find all running SQL Server Instance on a machine ? TIP #70

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 entire running instance on your machine.

Enjoy this Trick.

Thanks & Best Regards,
RJ!!!

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 as well on network

See below screen snap for detail

Enjoy !!!

RJ