A breakpoint tells the debugger that an application should break or pause execution at a certain point. When a break occurs, you can use available tools to evaluate your variables. A breakpoint will stop your code on the line of the source code which will be executed next. When the debugger breaks program execution, the program is broken and it remains in the break mode until you click Step Into, Step Over, Step Out or Run to continue the execution.
The Breakpoints window lists all breakpoints currently set in your program and displays their properties. Using the Breakpoints window, you can delete, enable or disable breakpoints, or go to the source code corresponding to a breakpoint.
The debugger cannot operate a breakpoint in the run mode. You can place a breakpoint in the run mode but it will be bound when the debugger enters the break mode.
Breakpoint status is indicated by symbols that appear in the gray margin, at the left, in the source window. They are:
The dbForge Fusion for SQL Server debugger provides many ways to set breakpoints:
Using the shortcut menu
Using the Debug menu
Here are also two commonly used techniques to set a breakpoint in a source window:
The breakpoint icon appears in the gutter.
To delete a breakpoint, perform either of the following:
You can delete all breakpoints by choosing Delete All Breakpoints on the Debug menu or by clicking the corresponding button on the Breakpoints window toolbar.
You can enable or disable a breakpoint by selecting the checkbox at the appropriate line in the Breakpoints window. You can also click the Disable/Enable All Breakpoints button in the Breakpoints window to disable all breakpoints if at least one breakpoint is enabled. Otherwise, it enables all breakpoints.