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

jwcolby jwcolby at colbyconsulting.com
Mon Jun 11 08:49:11 CDT 2007


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




More information about the dba-SQLServer mailing list