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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
