What is the purpose of Model database ?

 Posted by PandianS on 12/5/2010 | Category: Sql Server Interview questions | Views: 4899 | Points: 40

1. The Model database is a Stencil or Template for creating an user-defined database.

2. If any Objects (Tables, Stored procedures or Users) that need to exist in all our user defined database should be placed in Model database first.

3. When placing these kind of objects in Model database, will increase the minimum size of our user defined database

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: SheoNarayan on: 12/5/2010 | Points: 10
Good one!

Login to post response