Running a Routine Object

Run a routine object to obtain SQL results from the database.

Prerequisites 

Connect to your database server through a connection profile. Save or deploy the routine object to a database.

  1. In Data Source Explorer, find the routine object in the navigation tree.
  2. Right-click the object and select Run.
    Note: If the object includes parameters, the Configure Parameters dialog appears. Edit parameter values as necessary.
  3. Click OK to run the object.

    The SQL Results view displays the status of the run instance and execution details, and returns result sets and server messages, if any.

Related concepts
Procedural Routine Objects
Related tasks
Creating a Launch Configuration for Routine Procedural Objects
Viewing SQL Results