Instructions for accessing SQL Server 7.0:

0. [off-campus only] Create a database: Go to SQL Server Enterprise Manager to do this. In 7.0, just click on the yellow cylinder icon to create a new database. In 6.5, click on the yellow cylinders "manage databases" icon, and then you'll be able to create a database (yellow cylinder icon again). Pick reasonable values for the parameters; it doesn't much matter for this database.

1. [off-campus only] From the start button at the bottom left of the screen, select Programs, Microsoft SQL Server 7.0, SQL Query Analyzer. It will ask you what server, db, etc. you want to use (unless you're on-campus, in which case it plops you right into an existing database with your login name). In 6.5, that won't work. Instead of Query Analyzer, use ISQL_w (interactive SQL), then select the database.

2. [on-campus only] Login to NT using your login name on domain CSEPCLAB and start SQL Server 7.0 from the Programs menu. Then start Query Analyzer. Click on the elipses button and pick ISQL01 as the db server to connect to and use Windows NT authentication. (Notice that at either Step 1 or 2 if you get an error message regarding ODBC driver please click OK to continue, everything should be fine). This will put you inside an existing database.

3. You're in. The SQL Query Analyzer (and ISQL_w) should be very easy to use and you can (should) play with the menu options listed so that you can see what each does.

4. Run first the script that creates the tables (by saving the proper mscreate.sql script into a file and opening it in Query Analyzer or ISQL_w).

5. Then open and run the proper populate script.

6. Type a simple query for testing - something like

select * from employee

You should see some results. If you got here, congrats, you can call yourself a DBA :-)