|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
17/04/2008, 20h32
|
#1 |
Messages: n/a
Hébergeur: |
discover all my SQL
Is there a free tool that will discover all my SQL servers on the network?
Appreciate your . |
|
|
21/04/2008, 03h52
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: discover all my SQL
You can use the following command line options:
osql -L isql -L SQLPing from http://www.sqlsecurity.com/Tools/Fre...5/Default.aspx Some articles on DMO, SMO, OLEDB, etc. http://www.sqldbatips.com/showarticle.asp?ID=45 http://sqldev.net/misc/OleDbEnum.htm http://sqldev.net/misc/EnumSQLSvr.htm http://sqldev.net/misc/ListSQLSvr.htm http://blogs.msdn.com/sushilc/archiv...14/242395.aspx Note that no method is perfect, for example with sql browser not running (or with the service explicitly configured not to broadcast) you may not see all of the servers in your network. "OA" <omrana@verizon.net> wrote in message news:OdX8alLoIHA.1420@TK2MSFTNGP03.phx.gbl... > Is there a free tool that will discover all my SQL servers on the network? > > Appreciate your . > > |
|
|
|
| Outils de la discussion | |
|
|
