Installing SQL Server 2000 and Using Query Analyzer and Enterprise Manager, Exercises of Database Management Systems (DBMS)

Download Installing SQL Server 2000 and Using Query Analyzer and Enterprise Manager and more Exercises Database Management Systems (DBMS) in PDF only on Docsity!

Installation Process

1. Double click the “AUTORUN ” icon in the SQL Server 2000 CD.
2. Click “ SQL Server 2000 Components ”
3. Click “ Install Database Server ”

4. Click “ Next ”
5. Choose the option and Click “ Next”

8. Click “ Yes”
9. Choose “ Server and Client Tools ” and click “ Next ”

10. Write down the “ Instance Name” and click “ Next”
11. Choose your option and click “ Next ”

14. Click “Next”
15. Click “ Finish”

How to Use Query Analyzer

To create a database by using Query Analyzer ; write down the command in query

window and Press F5 or click Execute Query (F5 ) button on tool bar.

To use the particular database select that corresponding database from combo box

Inserting Comments To comment a command in Command widow, we use “ /*” in the beginning and “*/” in the end of the command. To comment the single line, we use “- - “

How to Use Enterprise Manager

To see the table in the Enterprise Manager expand tree

Click on the tables than you will see tables in the right pane. There will be some tables which are system tables and some that you have made. You can differentiate between them by column Type. There will be two entries in this column: (1) user (2) system

You can also insert the data into the tables

To create a new table using enterprise Manager:

1. To “ create” a table using “Enterprise Manager”, Right Click on the tables and Select “ New table ”

2. Enter the details of the table

3. To set a “ default value” , select the column and set its default value in default values row.

4. To set a primary key, Right Click on the Column and Select “ Set primary Key ”

5. And save the table and write its name