Adds an abstract plan group.
sp_add_qpgroup new_name
is the name of the new abstract plan group. Group names must be valid identifiers.
Creates a new abstract plan group named dev_plans:
sp_add_qpgroup dev_plans
Use sp_add_qpgroup to add abstract plan groups for use in capturing or creating abstract plans. The abstract plan group must exist before you can create, save, or copy plans into a group.
You cannot run sp_add_qpgroup in a transaction.
The permission checks for sp_add_qpgroup differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage abstract plans privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be the database owner or a user with sa_role |
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 |
|
Commands set
System procedures sp_help_qpgroup