RE: How to find all the SQL Server servers

in MSSQL, try
osql -L

C:\Program Files\Microsoft SQL Server\MSSQL$PROD1\Binn>osql /?

usage: osql              [-U login id]          [-P password]


  [-S server]            [-H hostname]          [-E trusted connection]

  [-d use database name] [-l login timeout]     [-t query timeout]

  [-h headers]           [-s colseparator]      [-w columnwidth]

  [-a packetsize]        [-e echo input]        [-I Enable Quoted

Identifiers]


  [-L list servers]      [-c cmdend]            [-D ODBC DSN name]

  [-q "cmdline query"]   [-Q "cmdline query" and exit]

  [-n remove numbering]  [-m errorlevel]

  [-r msgs to stderr]    [-V severitylevel]

  [-i inputfile]         [-o outputfile]

      <EOF> batch processing
      Auto console width scaling
      Wide messages
      default errorlevel is -1 vs 1

-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith_at_kmg.com] Sent: 16 September 2004 23:48
To: oracle-l_at_freelists.org
Subject: How to find all the SQL Server servers

Is there a utility I can run to find all the servers on our network that have SQL Server installed?

Thanks!
Ron

--
http://www.freelists.org/webpage/oracle-l



This email and any files transmitted with it are intended for the named recipient only. The information contained in this message may be confidential, legally privileged or commercially sensitive. If you are not the intended recipient you must not reproduce or distribute any part of the email, disclose its contents to any other party, or take any action in reliance on it. If you have received this email in error, please contact the sender immediately by return email and delete this message from your computer.

--
http://www.freelists.org/webpage/oracle-l