Posted by Beowulf on 12/01/06 00:33

Erland Sommarskog wrote:
> Beowulf (beowulf_is_not_here@hotmail.com) writes:
>
>>The result is the same as when right-clicking and choosing New Database
>>in EM.
>>...
>>SELECT @@VERSION
>>
>>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
>>23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Personal
>>Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
>
> Hm, Personal Edition? But Books Online says that Auto-Close is only on
> by default for MSDE, so it should be off by default on Personal.
>
> I tried flipping the AutoClose on model on my Developer Edition, and
> new databases followed the setting on model. There could still be something
> hardcoded for Personal, but I doubt.
>
> I would try:
>
> ALTER DATABASE model SET AUTO_CLOSE ON
> go
> ALTER DATABASE model SET AUTO_CLOSE OFF
>
> and also restart SQL Server.
>
> Yes, I'm clutching at straws.

Thanks for the suggestions. I'll try that out and report back.

• Next in forum: Re: PLEASE PLEASE HELP - How can I get a return value from a SQL Stored Proc is ASP.NET?
• Prev in forum: Re: SELECT UNTIL ?
• Thread view: Re: Default "Auto Close" to no for entire server?

[Reply to this message]