Posted by Beowulf on 11/27/06 17:27

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: Re: How to export SQL Database properties
• Prev in forum: How to export SQL Database properties
• Thread view: Default "Auto Close" to no for entire server?

[Reply to this message]