sp_copy_all_qplans

Description

Copies all plans for one abstract plan group to another group.

Syntax

sp_copy_all_qplans src_group, dest_group

Parameters

src_group

is the name of the source abstract plan group.

dest_group

is the name of the abstract plan group to which the plans are to be copied.

Examples

Example 1

Copies all of the abstract plans in the dev_plans group to the ap_stdin group:

sp_copy_all_qplans dev_plans, ap_stdin

Usage

Permissions

Any user can execute sp_copy_all_qplans to copy an abstract plan that he or she owns. Only the System Administrator or Database Owner can copy plans that are owned by other users.

See also

System procedures sp_copy_qplan, sp_help_qpgroup