faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

8 of 8 people (100%) answered Yes
Recently 8 of 8 people (100%) answered Yes

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')
----------------------------------------------------------------------