[dba-VB] Get list of servers, databases and tables in a database

Charlotte Foust cfoust at infostatsystems.com
Mon Jun 11 09:54:53 CDT 2007


View menu, Server Explorer.

Charlotte 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, June 11, 2007 6:49 AM
To: dba-vb at databaseadvisors.com; dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-VB] Get list of servers, databases and tables in a
database

I forgot to specify that I am using VB.Net for this.  So I need to know
how to do all this inside of VB.Net. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, June 11, 2007 9:26 AM
To: dba-sqlserver at databaseadvisors.com; dba-vb at databaseadvisors.com
Subject: [dba-VB] Get list of servers, databases and tables in a
database

I need to allow a user (me) to navigate through my servers, databases
and tables in databases to select a specific table, for example to
export to CSV.  Does anyone know how to determine instances of database
servers, then get lists of databases in those servers, then get tables
in a specific database?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com





More information about the dba-VB mailing list