For some reason I had a database called "federation" which has caused some confusion.

The USE FEDERATION <fed_name> (<dist_id> = value) WITH RESET re-wires the connection to the federation member on the SERVER side. So technically from the client's side we're still connected to the original database. Thus USE <original_database> will have no effect. In order to get back to the original database, you have to execute USE FEDERATION ROOT WITH RESET.

Assumptions: We are having two databases say "A" and "B",and by default "A" is the database to which we are connected.Now follow the following steps.

• Execute USE FEDERATION <fed_name> (<dist_id> = value) WITH RESET,FILTERING=OFF
• Perform some operation like insert into table or create table.
• Execute USE B,now defualt database will be selected as B.
• Execute USE FEDERATION ROOT WITH RESET.
• Now run a select query on a table which is part of database "A".Query will be executed successfully.But default database selection will be "B".Since we have used, "USE B" command database name in dropdown will change but internally we are connected to A.Moreover we can go and manually change the database name from dropdown.So i think when we are connected to a database using federation in that case we should not allow user to change database name in either of the cases.

Can't reproduce as outlined in your last comment. Is the same table available in both A and B databases? Can you please attach some screen shots?