When switching between tables, views and stored procedures using different databases, the selected database will change to a previously used database (Object Explorer)

Toad Data Point
1

I am pulling my hair out!

Using SQL Server and navigating with the Object Explorer, I will often times switch databases, and then change between views and tables and stored procedures. Often times after I have changed a database, and then change from tables to views, the database will change back to one used previously in the Object Explorer. I believe there is a setting to prevent all of this unintended switching, but I can’t find it and/or it is not named intuitively enough for it to catch my eye.

Can someone help me with this?

2

I used to have the same problem but I changed one of the settings. Try this:

Go to Options --> Database --> General --> Uncheck all the check boxes in the “Open on New Connection” section.

3

Another useful option is to change your Object Explorer Display Mode to “Connection Tree List”, per the snap cap below.

This allows you to see at a glance which data sources TDP is connected to, and offers quick navigation between those sources.

TDPConnectionTreeListMode.png