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 ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
