The following sections provide step-by-step instructions for managing 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:
From the SQL Server Enterprise Manager, click the plus (+) sign next to the server that will contain the database.
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.
Select the General tab and enter a name for the ...