How to find the databases on a server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dom <dolivastro@xxxxxxxxx>
Date: Tue, 25 Sep 2007 10:45:20 -0700

I'm trying to write an all-purpose program that will:

1. list all the servers on the network.
2. list all the databases on any one server once it is clicked.
3. list all the tables in a database once it is clicked.
4. list all the columns in a table once it is clicked.

The first step I can do with SqlDataSourceEnumerator. But I get only
the names of the servers, not the instance names.

My intention was to call SqlConnection.Open() on each server returned
by the Enumerator, but this fails, apparently because the enumerator
returns the name "CASSIUS" and not "CASSIUS\SQLEXPRESS".

How can I do what I want?

.

Follow-Ups:
- Re: How to find the databases on a server
  - From: William Vaughn
- Re: How to find the databases on a server
  - From: Dom

Prev by Date: Re: do release builds have the same amount of info in exceptions? e.g. will exceptions cought in release builds contain stack trace etc.?
Next by Date: Jet database engine could not find the object 'Expr...'
Previous by thread: do release builds have the same amount of info in exceptions? e.g. will exceptions cought in release builds contain stack trace etc.?
Next by thread: Re: How to find the databases on a server
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL active - active cluster hardware design?
... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
(microsoft.public.sqlserver.clustering)
Re: SQL active - active cluster hardware design?
... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
(microsoft.public.sqlserver.clustering)
Re: SAN (NetApp SnapMirror) replicated Exchange databases usability
... to stage Exchange 2007 servers at siteB with SG's and databases that are ... This is achieved by having Exchange ...
(microsoft.public.exchange.design)
Re: Best way to updat TNSNames.ora in all servers
... We have many unix servers running Oracle ... that be the case then I would still work to consolidate the databases ...
(comp.databases.oracle.server)
Re: Why does SQLBrowseInfo call take so long?
... I did a similar technique to resolve DNS ... So what I did was start one thread per resolution, ... have 20 servers, this means that it will take 100 seconds to resolve, but if you do them ... if there is some other approach to listing all available databases ...
(microsoft.public.vc.mfc)