Hello!
When I expand the "databases"-folder in the Object Explorer in SQL Management Studio Express it tends to load ALL databases that exists on my shared host. This results in very long delays (the app freezes totally and sometimes also crashes).
I just need to see the object tree of one database.
Is there any way to overcome this issue?
Perhaps.
Run this: DENY VIEW ANY DATABASE TO public and hope the login you are using is dbo...
I'd expect its down to your access, where you can see everything.
Try setting up another SQL account that can only have access to the required database then connect to SQL Management Studio using that account to see if the load times are better.
Arvixe have posted a solution that makes the loading of databases very much faster.
Take a look at it here, if you're interested.