Creating databases
To create a database
From the File menu, click New Database.
In the New Database dialog box, enter a name and location for the new database. Click the browse (...) button to browse to the location.
(Optional) To share the database, select the Share this database with other users check box.
Type a user name for the database.
(Optional) Type a password for the database.
Click OK.
If you are using MSDE (Microsoft SQL Server Desktop Engine), you should be aware of the size of your database so that you do not exceed the 2 GB limit. |
For information about naming databases and acceptable file names, see Naming a database.