Displays information about engine group assignments, bound client applications, logins, and stored procedures.
sp_showcontrolinfo [object_type, object_name, spid ]
is AP for application, LG for login, PR for stored procedure, EG for engine group, or PS for process. If you do not specify an object_type or specify an object_type of null, sp_showcontrolinfo displays information about all types.
is the name of the application, login, stored procedure, or engine group. Do not specify an object_name if you specify PS as the object_type. If you do not specify an object_name (or specify an object_name of null), sp_showcontrolinfo displays information about all object names.
is the Adaptive Server process ID. Specify an spid only if you specify PS as the object_type. If you do not specify an spid (or specify an spid of null), sp_showcontrolinfo displays information for all spids. Use sp_who to see spids.
Shows all user-assigned execution class-to-object bindings:
sp_showcontrolinfo
Displays the execution class of the isql application:
sp_showcontrolinfo 'AP', 'isql'
Displays the execution class for all processes assigned to engine groups:
sp_showcontrolinfo 'PS'
Displays the execution class for spid 7:
sp_showcontrolinfo 'PS', null, 7
When used with no parameters, sp_showcontrolinfo displays information about all user-assigned engine group assignments, bound client applications, logins, and stored procedures. When used with the object_type parameter, sp_showcontrolinfo provides information on an individual basis about application, login, or stored procedure bindings to an execution class, engine group compositions, and session-level attribute bindings. See the Performance and Tuning Guide for more information.
Unless object_type is PR, execute sp_showcontrolinfo from the master database. If object_type is PR, execute sp_showcontrolinfo from the database in which the procedure resides.
If object_type is null, sp_showcontrolinfo displays execution class information for objects that match the other parameters.
If object_name is null, sp_showcontrolinfo displays the binding information for all applications, logins, and stored procedures.
If spid is null, sp_showcontrolinfo displays execution class information for objects that match the other parameters.
Any user can execute sp_showcontrolinfo.
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 |
|
System procedures sp_addexeclass, sp_bindexeclass, sp_clearpsexe, sp_dropengine, sp_dropexeclass, sp_showexeclass, sp_showpsexe, sp_unbindexeclass, sp_who
