How to Set, Disable and Delete Breakpoints in SQL Server Management Studio

To toggle a breakpoint, position a cursor to the line of code and press F9:

toggle_breakpoint_ssms

You can toggle a breakpoint with a left mouse click left of the line of code, and the red circle that denotes a breakpoint will show up and dissapear.

To delete all breakpoints, press CTRL+SHIFT+F9 or go to the Debug menu -> Delete All Breakpoints:

delete_all_breakpoints

To disable all breakpoints without deleting them, go to the Debug menu -> Disable All Breakpoints:

disable_all_breakpoints

To open the Breakpoints window that lists all the breakpoints set in the current Query Editor, allows you to manage them, press CTRL+ALT+B:

open_breakpoints_window

You can open the Breakpoints window from the Debug menu -> Windows -> Breakpoints:

open_breakpoints_window_menu

To start or continue debugging, press ALT+F5 or go to the Debug menu -> Start Debugging:

start_debugging_menu

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">