List od SQL Servers, Database and Tables

  • Thread starter Thread starter M
  • Start date Start date
M

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
 
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!
****************************************************************************
****
 
Back
Top