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.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

System procedures sp_copy_qplan, sp_help_qpgroup