List od SQL Servers, Database and Tables

[M]

In .NET (pref. c#) how does one get a list of all available SQL Servers,
databases and tables. I need to allow the connection to a database, etc, on
the fly. kind of like what happens in SQL Query Analyzer
thanks
m

[Cowboy \(Gregory A. Beamer\)]

AFAIK, you still have to use SQL DMO to enumerate SQL objects. SQL DMO is a
COM library, which means some COM interop.

You could use the tables in the master database for objects on a single
server, but this means a user has to be created that has rights to the
master database, which is a potential security hole. You can reduce the risk
by using the stored procs in the master database, of course. This does
nothing for enumerating the actual servers on your network.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge

************************************************** **************************
****
Think Outside the Box!
************************************************** **************************
****
"M" <ra**@beethoven.com> wrote in message
news:e%******************@tk2msftngp13.phx.gbl...

In .NET (pref. c#) how does one get a list of all available SQL Servers,
databases and tables. I need to allow the connection to a database, etc, on the fly. kind of like what happens in SQL Query Analyzer
thanks
m