SQL Query Analyzer Help
Debug Procedure Dialog Box
Use the Debug Procedure dialog box to specify parameter values and debug a stored procedure.
Options
Procedures
Select the stored procedure to be debugged.
Parameters
List the parameters defined for the stored procedure.
Data type
Show the data type of the selected parameter.
Direction
Show whether the selected parameter is an input or output parameter.
Value
Specify a value for the selected parameter.
Set to null
Specify a null value for the selected parameter.
Auto roll back
Automatically rolls back all work performed during execution of the procedure.
Execute
Debug the stored procedure using the specified values.