Please, choose object (procedure or function) you would like to debug. Open it in editor, as discribed in Explain Edit.

1. To set breakpoint double click ruler of the line or go to Run/ToggleLine Breakpoint( Ctrl+Shift+B). Marker will appear.



2. To lauch debug mode you can select procedure in "Data Source Explorer" and click "Debug..." contex menu item. Alternatively, you can click "Debug..." contex menu of editor





3. "Configure parameters" dialog box will apear. Set parameters and click OK when ready.



4. Debugger will stop on breakpoint.



5. Make step or press F6.



6. Please, look at "Parameters" tab of "SQL Results View". They are the same as after launching "Run..." SQL Results View.



7. Now, lets debug function from Explain Run.... We have already this function opened in editor due previous activity. Set breakpoint. And launch debug.





8. "Configure parameters" dialog box will apear. Set parameters and click OK when ready.



9. Debugger will stop on breakpoint.



10. Make step or press F6.