In SQL Management Studio, you can query a database table by right clicking it in the object explorer and selecting 'Select XX Rows'. A window opens showing the query and results. The query includes the database and scheme names. This action does not affect the selected database connection in the toolbar's dropdown list.
I use this as a starting point for manually writing queries, and it's quicker to just query the tables. So I regularly change the current database connection to the database I just created the query for.
Is there a way to make the database connection in the toolbar's dropdown list automatically change to the database where you start a query in the object explorer?
This is solved since the release of SSMS 2016.