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

> Yes. Autoclose is a very dubious option. There are some contexts where
> it's good, but not many.
>
> I believe that Autoclose is on by default in MSDE instances. Where it may
> make sense, because the database is only accessed from an application that
> is run infrequently. But as soon as you start to access the server with
> Enterprise Manager, autoclose becomes a problem. (Note that the license
> terms does not permit you to access MSDE from EM!)
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>

Thank you again. This is not MSDE of course. I'll try to find out somethig
about this option (how to switch off etc.).

Cheers.

[Back to original message]