Posted by Beowulf on 12/07/06 19:50

Erland Sommarskog wrote:
> 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.)

Thanks for the suggestions, Erland. I'll go dig out my pad of Post-Its.

• Next in forum: Asymmetric communication from ms-sql-m protocol from an SQL Cluster
• Prev in forum: Server Properties
• Thread view: Re: Default "Auto Close" to no for entire server?

[Reply to this message]