Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jason Brimhall Model DB RE: Model DB

  • June 11, 2010 at 8:04 am

    #1179193

    michael.kaufmann (6/10/2010)

    Just verified the finding in SQL Server 2005:

    - With MODEL being in READ_ONLY mode, when creating a database using the wizard, it is created read_only. No more changes are possible.

    - With MODEL still in READ_ONLY, when creating a database via a SQL script, it is created in read/write mode and tables etc. can be added.

    Very interesting behavior--especially given the fact that BOL states one cannot set the MODEL database to READ_ONLY (that's why I did not get my point).

    Agreed Mike. Never knew this. Just checked by creating DB with wizard and also script.

    But still, Model is an empty shell and all new databases created should copy exactly the properties Model DB had if created by default script - Create database Testmenow ?

    SQL DBA.