Posted by Mr Curious on 11/23/05 14:19

>> One remark - if Auto close option is responsible - the server
>> administrator should have similair problem?
>> As far as I know he doesn't (I forgot to mention). That's why I suspect
>> some security issue.
>
> I think the problem is due to that EM accesses the databases to see if you
> have permission to it. Since sa has permission to all databases anyway,
> EM might bypass the check for him.
>
> The command to turn it off is ALTER DATABASE db SET AUTO_CLOSE OFF.

Thank you very much.

[Back to original message]