RE: How to find available SQL Server on local network

From: "Jakob Christensen" <jch@xxxxxxxxxxxxxxxx>
Date: Fri, 29 Apr 2005 01:34:11 -0700

You can do this using SQL-DMO. Add a reference to sqldmo.dll and sqldmo.rll
to use SQL-DMO. The Application object of SQL-DMO has a ListAvailableServers
method which will give you all SQL Servers on the network (if you are running
Windows 2000 and up).

You can also connect to an SQL Server instance and enumerate all objects for
that server (using the SqlServer object).

Links:
http://support.microsoft.com/default.aspx?scid=kb;en-us;287737
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con03_8q44.asp

Of course, the code will be a bit different in VB.net.

HTH, Jakob.

"Job Lot" wrote:

> Using VB.NET how can I find all available SQL Server on a local network and
> list all the databases in each server.
>
> Thanks
.

References:
- How to find available SQL Server on local network
  - From: Job Lot

Prev by Date: Re: Easiest database to use (free)?
Next by Date: multiple sort criterias for any class; arraylist performance
Previous by thread: How to find available SQL Server on local network
Next by thread: multiple sort criterias for any class; arraylist performance
Index(es):
- Date
- Thread

Relevant Pages

Re: backupRestore progress bar
... SQL-DMO is an acronym for SQL Distributed Management Object and is a full ... object model to manage and administer SQL Server.. ...
(microsoft.public.sqlserver.msde)
Re: Problem Executing Stored Procedures
... Both SQL Server and Agent are running under the Local System account so they ... should have enough privileges. ... The same application that is having problems with SQL-DMO also uses SQL-DMO ... and both procedures you are mentioning are run with success... ...
(microsoft.public.sqlserver.msde)
Re: "Best Practices" way to distribute MSDE
... if SQL-DMO is locally present) and try a connection to the server... ... if you can't connect with that login, ... object privileges... ... Andrea Montanari (Microsoft MVP - SQL Server) ...
(microsoft.public.sqlserver.msde)
RE: How to find available SQL Server on local network
... QueryInterface for interface SQLDMO.NameList failed??? ... > You can do this using SQL-DMO. ... > You can also connect to an SQL Server instance and enumerate all objects for ... >> Using VB.NET how can I find all available SQL Server on a local network and ...
(microsoft.public.dotnet.general)
RE: How to find available SQL Server on local network
... Doesn't it show instances installed on local machine? ... > You can do this using SQL-DMO. ... > You can also connect to an SQL Server instance and enumerate all objects for ... >> Using VB.NET how can I find all available SQL Server on a local network and ...
(microsoft.public.dotnet.general)