O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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 User Databases

Unlike system databases that are always installed by default, you need to create and configure all user databases manually. The sections below explain the processes involved in creating, altering, viewing, and deleting user databases.

Creating a Database

In SQL Server 2005 user databases can be created using either SQL Server Management Studio or the CREATE DATABASE command. Creating a database using either method is a relatively straight-forward operation that can be done fairly quickly. However, setting the various database options correctly requires detailed understanding of the databases requirements and anticipated usage characteristics.

SQL Server Management Studio is the easier of the two options and presents a graphical ...

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