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 |