|
|
Posted by Beowulf on 11/27/06 21:49
francois.bourdages@harfan.com wrote:
> 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?
>
> 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.
"Auto Close" is set to No in model, but if I create a new database in
Enterprise Manager, then the new database has "Auto Close" checked. Is
this a bug in SQL Server 2000?
Navigation:
[Reply to this message]
|