Posted by Erland Sommarskog on 11/23/05 10:20

Mr Curious (courious@somewhere.eu) writes:
> Thank you. Can I (or rather a server administrator) change this option? Is
> it safe?

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

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]