Entry

Database: Microsoft SQL server: Enterprise Manager: Database: Create: New: How create new database?

Dec 22nd, 2003 13:52
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 14 December 2003 - 11:50 pm -------------------

Database: Microsoft SQL server: Enterprise Manager: Database: Create: 
New: How create new database?

---

Steps: Overview:

 1. -Open Microsoft SQL server 'Enterprise Manager'

 2. -Expand 'Microsoft SQL Servers' in the left pane
     (by clicking on the '+')

 3. -Expand 'SQL Server Group' in the left pane
     (by clicking on the '+')

 4. -Right click now on the server of your choice
     (e.g. your (local) (Windows NT) server

 6. -select from list 'New Database...'

 7. -A dialog box 'Database Properties' opens

 8. -type a name for your database in the text box 'Name:'

     e.g.

      mydatabase

 9. -Possibly adapt the size

10. -click button 'OK'

11. -To check if this database is added, expand this server
     (e.g. click on the '+' of '(local) (Windows NT)')

     1. Expand 'Databases' (click on the '+')

     2. You should see now the newly created database
        in the list (e.g. 'mydatabase')

----------------------------------------------------------------------