Search
Active

3
Sign in to vote
0
Sign in to vote
Sign in
to vote
Type: Suggestion
ID: 508321
Opened: 11/4/2009 2:41:37 PM
Access Restriction: Public
0
Workaround(s)
Model is a great way to "model" all new databases. Unfortunately there are two limitations that I encounter often enough that I thought I would file an enhancement request:

(1) you can't turn off this inheritance; in order to create a non-model-based database, you must create the database, allow it to inherit everything from model, then create a script that drops all of the user-defined objects.

(2) you can't set up inheritance for database settings such as ALLOW_SNAPSHOT_ISOLATION. Several times now I have forgotten to turn this on and while it's easy to correct it would be great for this type of property to be editable on model.

I went over some similar ideas in Connect #415343, but those revolved more closely around tempdb (which automatically gets re-created from model when the service restarts - here I am talking about creating databases manually).
Details (expand)
Product Language
English

Category

SQL Engine
Proposed Solution
(1) allow an option on CREATE DATABASE such as IGNORE_MODEL. This would just create an empty database as if you hadn't made any customizations to model.

(2) allow settings like SNAPSHOT_ISOLATION_ON to be set for model. Or provide a way to dictate what settings will apply to new databases even if you don't apply them directly to model itself.
Benefits
Improved Administration
Other Benefits
 
File Attachments
0 attachments
Sign in to post a comment.