To edit the list of stored procedures displayed

  1. From the SP Test tool, right-click anywhere on the tree view; then click Edit List of Stored Procedures Displayed.
  2. If you have checked Also remove from database, the SP Test tool invokes the File Name to Save Drop Commands dialog box. Here, you specifiy the name of a command file that the SP Test tool generates to drop the checked stored procedures from their XDB location(s). The SP Test tool executes this command file when you click Save.
  3. Check the box to the right of each stored procedure you want to remove from the list.
  4. If you want to remove the checked stored procedures from the repository as well as the displayed list, check Also remove from database (optional).
  5. Click Remove to remove the checked stored procedures.
Note: If you leave Also remove from database unchecked, stored procedures you have removed from the list reappear when you start the Stored Procedure Test tool again, or when you click Refresh list of stored procedures Refresh list of stored procedures.
Parent topic: How to...