O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 Registered Servers view to select a type ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required