Posted by Mr Curious on 11/23/05 09:11

Uzytkownik "Erland Sommarskog" <esquel@sommarskog.se> napisal w wiadomosci
news:Xns9716F29CBA659Yazorman@127.0.0.1...
> 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
>


Thank you. Can I (or rather a server administrator) change this option? Is
it safe?

Regards.

[Back to original message]