October 28

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.


Copyright 2021. All rights reserved.

Posted October 28, 2011 by Timothy Conrad in category "Databases

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B