Posted by francois.bourdages on 11/27/06 20:17

When you create a new DB, SQL Server make a copy of database "model".
So make sure that the option auto close is set as you like in "model",
before create a new DB.


Beowulf wrote:
> I was having this problem:
> http://groups.google.com/group/microsoft.public.sqlserver.server/msg/e36e423972323378?dmode=source
>
> with it taking an inordinate amount of time to enumerate the databases
> on my local SQL Server instance, so I went through all the local
> databases and unchecked "Auto Close" on the "Options" tab of the
> Database properties in Enterprise Manager.
>
> This cleared up the problem nicely. In EM or through SQL-DMO, the
> databases on the local server enumerate quite quickly now. However, any
> new databases that are created have "Auto Close" checked, so eventually
> the original problem will resurface.
>
> Is there some way to tell SQL Server to create any new databases with
> "Auto Close" set to No?

• Next in forum: Update Query using XQuery
• Prev in forum: Re: Some XQuery/SQL Server 2005 help please
• Thread view: Re: Default "Auto Close" to no for entire server?

[Reply to this message]