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 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 ...

Get Transact-SQL Desk Reference now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.