Creating Databases

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.

Creating Databases in SQL Server Management Studio

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:

  1. In SQL Server Management Studio, use the Registered Servers view to select ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial