Posted by Erland Sommarskog on 11/23/05 00:52

Mr Curious (courious@somewhere.eu) writes:
> I have a problem with Enterprise Manager - when I refresh list of tables
> or databases it hangs (is not responding) for long time - about 10-30
> minutes.
> What is more important during my refreshement users are unable to work
> normally - it hangs entire server.
> Some other details:
> 1. I am only dbo of one database with no administrative privilges.
> 2. There are no problems with Query Analyzer
> 3. Problem is related to one particular server - I don't have these
> difficulties with my local instance of SQL Server.

Sounds like there are several databases that are set to autoclose. Then
EM needs to open all of those, to see what permissions you have in them.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]