Starting the Stored Procedure & Function Debugger
You can start debugging a routine by using the Debug Routine button in the toolbar, after selecting a routine from the database treeview, or by using the context menu in the database treeview.
If the Stored Procedure or Stored Function has input parameters, the Edit Stored Procedure/Function Parameters dialog will be displayed.
Enter values for the parameters
The NULL columns signals a parameter to be NULL, while the Default columns tells the parameter to be the default, if it has a default assigned.
Click OK to continue to the debugger main window after editing the parameter values.
If there are no input parameters, the dialog will be skipped and we go straight to the debugger main window.
For more information on the debugging process, see Debugger Overview.