Hi guys,


We run a administrative maintenance app that has access to about 30 plus databases (same databases, with different names).  I need to be able to pull a couple of values from each database to present to the administrator as status information.

We use the connection manager.  I'm trying to just iterate through the available database connections, connect to the database, pull the value and move to the next.  Of course when done, I want to reconnect to the original database connection.  What is the easiest way to do this without user intervention?


Thanks,


Marcel