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:


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:


To disable all breakpoints without deleting them, go to the Debug menu -> 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:


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


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


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="">