Posted by Erland Sommarskog on 11/27/06 22:40

Beowulf (beowulf_is_not_here@hotmail.com) writes:
> "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?

What happens if you create a database from Query Analyzer, using the
CREATE DATABASE statement?

What edition of SQL 2000 do you have?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Transposing repetitive serial fields into Table structure
• Prev in forum: Re: Help with FOR XML - How do I return the results like this?
• Thread view: Re: Default "Auto Close" to no for entire server?

[Reply to this message]