Posted by Erland Sommarskog on 12/05/06 22:19

Beowulf (beowulf_is_not_here@hotmail.com) writes:
> 3. Stopped the MS SQL Server service (and dependent services)
> 4. Started the MS SQL Server service (and dependent services)
> 5. Ran this SQL batch in Query Analyzer:
>
> ALTER DATABASE model SET AUTO_CLOSE ON
> go
> ALTER DATABASE model SET AUTO_CLOSE OFF
>
> CREATE DATABASE stercus2000
>
> - Result: stercus2000 had Auto Close checked
>
> I'm stumped.

And you think I am not? :-)

The only I can suggest is a Post-It note which says "Don't forget to
set newly created databases to AUTO_CLOSE OFF".

I have no idea of what is going on. Maybe Personal Edition always sets
AUTO_CLOSE ON, despite that Books Online said that this applies to
MSDE. (I don't have any instance of Personal Edition installed to test.)


--
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: Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
• Prev in forum: Re: Default "Auto Close" to no for entire server?
• Thread view: Re: Default "Auto Close" to no for entire server?

[Reply to this message]