1.6. CHAPTER LAB EXERCISES
These lab exercises are optional but highly encouraged since working on the system is the only way to learn SQL. Lab Exercise 1 introduces using MSS. Lab Exercise 2 and beyond are RDBMS independent.
1.6.1. Lab Exercise 1: Introduction to Using Microsoft SQL Server
184.108.40.206. Microsoft SQL Server Enterprise Manager
Open a Microsoft SQL Server Enterprise Manager as follows.
Start – Programs – Microsoft SQL Server – Enterprise Manager
If prompted to log in, select “Use SQL Server authentication” and log in as sa with no password (unless you have changed the sa password during or after installation as you should on a production machine).
password: <leave blank>
In the Console Root window open
Console Root – Microsoft ...