SqlConnection.ConnectionString

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?

.

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: 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: Developer design Best Practices
    ... multiple smaller databases that were created adhoc on those servers for the ... SQL on these machines and than installed their application and pointed it ... production machines. ... Many of the objects in these databases are owned by not ...
    (microsoft.public.sqlserver.server)
  • Re: views in different databases
    ... provide a Centralized Primary Source of information. ... other downstream processes use the first. ... can not maintain DRI across databases, ... Some of these databases are on different servers. ...
    (microsoft.public.sqlserver.server)