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

• Next in forum: Re: How to drop one of the tempdb files
• Prev in forum: Re: There is a question when i work on Linkedserver~Pls kindly help me:)
• Thread view: Re: Enterprise Manager - problem

[Reply to this message]