How to view all sql server instances from the network.


Call Start->Run type cmd and click enter (start command line prompt). Now depending on version of installed sql server client tools run either from the following commands

sqlcmd -L

osql -L

isql -L

Try them in the given order. sqlcmd is the latest version of command line sql server utility. All of this utilities support -L param which lists all sql server instances from the network. However, isql shows only sql servers of 7.0 version and below, osql – only sql server 2000 and below and sqlcmd shows all sql server instances from the network. So to view all sql server in the network you better use sqlcmd -L command.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: