Go to ...

Techpository

A Better Technical Repository

RSS Feed

MSSQL: List SQL all network SQL server from the command line


 

From a command prompt use the follow:

sqlcmd -L

To send to a file use: sqlcmd -L >sqllist.txt

The older commands are isql and osql
I also use the “Data Sources (ODBC)” connector from Administrator Tools and start the creation of a System DSN.  From the SQL Server drop down box you can see the ones advertising themselves.