What is the purpose of MODEL database?

 Posted by Bandi on 11/30/2013 | Category: Sql Server Interview questions | Views: 1927 | Points: 40

model is a system database which is available in SQL server. It is used as a template for future user-defined databases. whenever you supposed to create a database in SQL Server model database will provide some default configurations/options.
To check the same thing do the following:
1) Change Recovery Model of model database to FULL ( SQL Server object explorer--> access model db properties --> go to Options Page )
2) Create one sample stored procedure in model database
3) Then, Create new database in SQL Server
4) Now you will get to know that your newly created database will have sample SP which is created in model database and also check the recovery model too

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response