O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

Database Basics

The following sections provide step-by-step instructions for managing a database.

Creating a Database

Before you can create tables and start to manage your data, you must create a database. Follow these steps to create a new database:

1.
From the SQL Server Enterprise Manager, click the plus (+) sign next to the server that will contain the database.
2.
Right-click the Databases folder. From the right-mouse menu, select the New Database menu option. The Database Properties dialog box appears (see Figure 8.4).
Figure 8.4. Creating a database with Enterprise Manager—General tab.

3.
Select the General tab and enter a name for the ...

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