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?