SQL Server uses the model database as the prototype for new databases. If you want new databases to have a particular setup, first modify the model database, and then create the new databases. Otherwise, you will have to modify the settings of each new database manually.
The easiest way to create a new database is by using SQL Server Management Studio. You can also create databases using Transact-SQL.
In SQL Server Management Studio, you set database properties with buttons and input boxes and let SQL Server do all the SQL detail work. Create a database with the default options by completing these steps:
In SQL Server Management Studio, use Registered Servers view to select a type ...