Lets say I have 10 databases per machine, together with my local machine that's a lot of stuff in the dropdown menu. I found a way to circumvent that, making (dev) life a lot easier: just using the linked server feature (pro version) by creating connection to special database and ctrl + dragn'drop all the other 9 databases into the connection.
Now I have one entry per server in the dropdown list, 5 instead of 50, and can access every database in every query (intermixing databases comes in handy for some queries).
But the *problem* is, everytime I switch the servers, it fetches the schema for all databases, which takes up to 20 seconds. It _doesn't_ do that if I expanded the according connection in the tree view first. Then, changing between servers is essentially just the query.
Please fix that, as it is really killing the workflow of easily switching between servers for me. :)
This post has been edited by Hannes K.: 15 December 2011 - 10:56 AM