This is the process for running a stored procedure.
Once
the stored procedure is built on the remote system, it can be invoked from
the Database Explorer view.
- Right-click the stored procedure and select Run.
- A parameter input panel is displayed if the stored procedure uses
input parameters. Specify the parameter values and click OK. When the run is completed, information about the run will be displayed
in the Data Output tab.
The Messages tab shows a summary of the run process.
The
Parameters tab shows the Input and Output parameter values of
the stored procedure.
The Results tab shows the result sets returned
by the stored procedure.