HW2, SQL Server

  1. From the start button at the bottom left of the screen, select Programs, Microsoft Visual Studio 97, Microsoft SQL Server 6.5, SQL Enterprise Manager.
  2. If your server manager window lists ISQL01, go to the next step. Otherwise, you need to do the folowing: In the "register server" window, click the "Trusted Connection" button. From the servers button, select ISQL01, then click "Register" and close the registration window.
  3. Click the "+" signs beside ISQL01, Databases, hw2, Objects, Tables. You should see the six tables there.
  4. At this point you can issue SQL queries by starting the SQL Query Tool, which is available on the Tools Menu. Please do not make any changes to the tables or data -- we're all sharing this DB, and it doesn't yet have the proper security.