Sunday, May 23, 2010

How Many Instances Available in SQL Server

Start -- Run -- Cmd

sqlcmd -L -- displays the list of sql server instances installed in the current machine. If the machine is connected to network, it displays all the instances which are available in the network including express edition versions.

No comments: