Watch this video to learn how to debug a stored Procedure.
Process Flow to Debug a Stored Procedure
To use the SQLScript debugger, proceed as follows: Open database Explorer.
- To open the debug panel, choose the Debugger icon on the right side of the screen.
- Use the Attach Debugger icon (plug icon next to the Active Session dropdown box) to link the debugger to your session.
- Specify the debug target which is the database connection you want to use and confirm by selecting OK.
You will see a success message appear in the upper right corner of the DB Explorer.
- Open the procedure for debugging from the context menu: Context Menu → Open for Debugging.
- Set breakpoints by clicking the line numbers.
- From the Context Menu of the procedure use the Generate CALL Statement
- Execute the Procedure
- Use the controls in the Debugger panel to Resume, Step Over, Step In, or Step Out.