Making Enterprise Manager faster with lots of databases

I wish I remember where I saw this posted. I owe mad props to someone but I can't remember who. If your server has lots of databases that you don't have access to and you connect using Enterprise Manager you may have noticed that it takes a loooong time to populate the Databases tab. This especially applies in the hosting world when you're dealing with a shared SQL Server.


This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2005/04/21/4599/