How to find all running SQL Server Instance on a machine

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.

Happy weekend.

Thanks & Best Regards,

 Rajat Jaiswal