BUG: Not All Database Options Transfer from Model to New Database

ID: Q181555


The information in this article applies to:

BUG #: 17820 (SQL 6.5)

SYMPTOMS

When creating a new database, only the following database options will be transferred from the model database to the new database:


   Select Into/Bulk Copy
   Truncate Log on Checkpoint 

The following databases options are not transferred to the new database:
Columns Null by Default
No Checkpoint on Recovery
Single User
DBO Use Only
Read Only


WORKAROUND

To work around this problem and set the desired database options, do either of the following:


STATUS

Microsoft has confirmed this to be a problem in SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: defaults settings checkbox checkboxes


Keywords          : SSrvAdmin kbbug6.50 kbbug6.00 
Version           : WINNT:6.0,6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 19, 1999