Running Stored Procedures from Object Browser

Use Object Browser to run a stored procedure and be prompted for parameters.

To run a stored procedure

1. In Object Browser, expand a server, and then expand a database.
   
   
2. Expand the Stored Procedures folder, right-click the stored procedure, and then click Open to display the Execute Procedure dialog box.
   
   
3. Click a parameter in the Parameters list, and then type a value in the Value box. Do this for each parameter you want to use.
   
   
4. Click Execute.

The EXECUTE statement for the stored procedure is displayed in the Editor pane and the result is displayed in the Results pane.