SQL2008 Enhanced integrated development environment

Enhanced integrated development Environment

Directory

Prepare for Work 1

Exercise 1: IntelliSense 2

Exercise 2: Use Error List 3

Exercise 3: Use single Step debugging 5

Preparatory work

Estimated time required to complete this experiment

30 minutes.

Goal

After completing this experiment, you will be able to:

New features of using SQL Server 2008 Management Studio

Prerequisite

Before completing this experiment, you must have:

Experience with writing Transact-SQL scripts and using SQL Server Management Studio.

Experiment scene

In this experiment, you will see the new features of the integrated development environment in SQL Server 2008.

These new features include:

Intelligent perception

Error List

Single-Step debugging

Virtual Machine Environment

Enable the Microsoft Virtual PC from the Start menu or desktop. If Virtual PC Console is not enabled, check the system tray and double-click the Microsoft Virtual pc in the system tray.

Select Sql08 and click Start.

After the virtual machine is running, you can send a Ctrl+alt+del command to the virtual machine by clicking on the right Alt+del.

In the Login window, enter the following information:

User Name:administrator

password:password01!