The model Database
The model database is aptly named, in the sense that it’s the model on which a copy can be based. The model database forms a template for any new database that you create. This means that you can, if you want, alter the model database if you want to change what standard, newly created databases look like. For example, you could add a set of audit tables that you include in every database you build. You could also include a few user groups that would be cloned into every new database that was created on the system. Note that because this database serves as the template fo...
- Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?
- from Beginning Microsoft® SQL Server® 2012 Programming
- Publisher: Wrox
- Released: April 2012
Share this highlighthttp://www.safaribooksonline.com/a/beginning-microsoft-sql/39279/