Possible to set breakpoint within Stored Procedure?

Toad for SQL Server
1

I would like to set a breakpoint within a stored procedure and then execute it but it seems it is not possible. Is there a way to do this?

Thanks,
Chris

2

Hi Chris,
probably I didn’t get you correct. But I can do this by right click on a SP in object list, select Debug, put cursor in desired place and set breakpoint (by Ctrl+B or from toolbar/menu). Then run it from Debug toolbar/menu or by F11.

Is this something you are looking for?