Find All Servers From Local Network and Installed SQL Server on Network

To create list of all the SQL Server on local network and SQL Server installed on the other systems around the network.

Go to command prompt and type in “osql -L” or “sqlcmd -L”.

Result:

shyamb4u

If you have a large number of SQL servers in your network, you can push the results of SQLCMD -L to an output file as DOS doesn’t allow you to scroll-up past a certain point. To do this you would simply type at the command prompt:

sqlcmd -L > D:\servers_filename.txt