Detailed Overview of Model Database in SQL Server - SQL Server DBA Tutorial

In this video you will learn about Model DataBase. Model Database is system Database in SQL Server that is used as template when we create New Database in SQL Server.

In this video you will learn following Items

  1. How to Create Objects such as Tables, Views, Functions those we want to Create By default in any newly Create Database by using Model Database
  2. What are the restrictions on Model Database
  3. What Settings/Configurations are used in TempDB from Model Database
  4. Does Create Database Statement take all the settings/Configurations of Model Database
  5. Does GUI ( Graphical User Interface) copy the setting from Model for New Database Create Process

What is Model Database in SQL Server - SQL Server Tutorial