Re: How to find the databases on a server
- From: Dom <dolivastro@xxxxxxxxx>
- Date: Thu, 27 Sep 2007 08:43:37 -0700
On Sep 25, 1:45 pm, Dom <dolivas...@xxxxxxxxx> wrote:
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?
Just replying to myself to get this post pushed to the top again. See
if I get any responses this time. Then I'll give up.
.
- References:
- How to find the databases on a server
- From: Dom
- How to find the databases on a server
- Prev by Date: "DataTable.CaseSensitive" problem
- Next by Date: TransactionScope vs DAAB DbTransaction
- Previous by thread: How to find the databases on a server
- Next by thread: Re: How to find the databases on a server
- Index(es):
Relevant Pages
|
