Toggle a Breakpoint

The act of setting a breakpoint on a Transact-SQL statement is called toggling a breakpoint.

Once the breakpoint is set, it’s represented by an icon in the gray bar to the left of the

statement. The icon is called a breakpoint glyph. Transact-SQL breakpoints are applied to a

complete Transact-SQL statement. When a breakpoint is toggled on, the debugger highlights

the associated Transact-SQL statement.

If there are multiple Transact-SQL statements on a line, you can toggle a breakpoint for each

statement. Selecting the gray bar on the left of the window toggles a breakpoint on the first

statement on the line. You can toggle a breakpoint in a subsequent statement by highlighting

any part of the statement, or moving the cursor into the statement, and then either pressing

or selecting

on the

menu. If you have multiple breakpoints on a line,

there’s only one breakpoint glyph in the gray bar on the left.

After a breakpoint is toggled, you can perform various actions on the breakpoint, such as

editing its properties or temporarily disabling it. For more information, see

Transact-SQL

breakpoints.

1. Select the gray bar to the left side of the Transact-SQL statement.

2. Alternatively, either highlight any part of the statement or move the cursor to the

statement, and then perform either action:

Press.

On the

menu, select.