School of Business Administration

Oakland University

Rochester, MI 48309-4401

September 2003

Query Analyzer and Enterprise Manager are the two frequently used tools for most SQL Server 2000 client users.

A. What are Query Analyzer and Enterprise Manager:

Query Analyzer:

The SQL Server Query Analyzer is your primary interface for running SQL queries or stored procedures. You will be using this utility throughout your database coureses.

2. Enterprise Manager:

SQL Server 2000 Enterprise Manager is the primary graphical administrative and development interface for SQL Server. There is very little SQL Server Enterprise Manager can do that you can't accomplish from a SQL command. However, using the Enterprise Manager is sometimes more convenient (especially when you are new to SQL Server 2000). You can use Enterprise Manger to create your own database, cope / delete tables, query / update tables without writing SQL commands.

B. How to use Query Analyzer:

select your target SQL Server: click the browser button (right to SQL Server input) and select ORADEV (Note, if you have a SQL Server database running on your local pc, the default SQL Server is your local SQL Server database).

Under Connect using, select SQL Server Authentication mode and type in your user id and password ( you may obtain your userid/password from your instructor), click OK.

Congratulations!....you are in Query Analyzer now:

The right pane is Query Analyzer where you write your SQL command, the left pane is Object Browser window (if you don't see this, just click Tools / Object Browser / Show/hide to display the window).

Please note: Northwind and pubs are the two default sample databases for learning purposes. You can practice your SQL command by using these two sample databases. However, it is strongly recommended that you create your own database for all your purposes, to know how, please see the next section How to use Enterprise Manager. Most importantly, don't try to query, update, delete or modify master, msdb, tempdb databases, these databases are system databases and not supposed to be used by client users.

Write your first SQL query command: in Query Analyzer, with Northwind database selected from dropdown list above the window, and type in: select * from Customers, and click Query -> Execute from the toolbar:

C. How to use Enterprise Manager:

Registering a Server: In order to use Enterprise Manger, you must register a server. to do so, click Start / Programs / Microsoft SQL Server / Enterprise Manager:

click Plus sign of Microsoft SQL Servers, select and right-click SQL Server Group -> New SQL Server Registration, you will see Register SQL Server Wizard:

click Next and select ORADEV and click Add:

at next screen, select The SQL Server login information that was assigned to me by system administrator (SQL Server Authentication).

Next screen, select Prompt for the SQL Serve account information when connecting:

Next screen, select Add the SQL Server(s) to an existing SQL Server Group:

click finish............., you are done.

To use Enterprise Manager, under SQL Server Group click ORADEV (Windows NT), and type in your user id/password:

after connecting the SQL Server, you will see the following screen, and you can do most activities graphically that you do with in Query Analyzer with SQL Command.

To create your own database: right click Databases, click New databases:

Just type in your new database name you choose, then you are done!