In TIP #70 we saw how to find all the running SQL SERVER instance in a network or a machine. to revise see below image. This tip is just opposite to tip #70 you don’t want that your co-worker see your SQL Server instance running on your machine machine. (There are several reason behind …
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 …