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

Martin Reid mwp.reid at qub.ac.uk
Mon Jun 11 08:37:55 CDT 2007


John
 
Sent you a demo of list
 
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974465
 

________________________________

From: dba-sqlserver-bounces at databaseadvisors.com on behalf of jwcolby
Sent: Mon 11/06/2007 14:26
To: dba-sqlserver at databaseadvisors.com; dba-vb at databaseadvisors.com
Subject: [dba-SQLServer] 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-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 





More information about the dba-SQLServer mailing list