Adding an existing stored procedure

You can add an existing stored procedure to a database stub by using the Add wizard.


  1. Using the Name list, select the stored procedure that you want to add to the stub.
    Note: When adding a stored procedure to a database stub, synonyms are not displayed for selection in the Add Stored Procedure window. However, you can add a query in the Add Query window and then use that query to learn from the database, which will import the synonym (if it exists) into the database stub.
  2. Optional: Click the plus button on the Parameters toolbar to add one or more new input, input/output, or output parameters to the new stored procedure.
  3. Click Next.
  4. Click Finish to close the Add wizard.