sys.dm_broker_activated_tasks
Returns a row for each stored procedure activated by Service Broker.
| Column name | Data type | Description |
|---|---|---|
spid |
int |
ID of the session of the activated stored procedure. NULLABLE. |
database_id |
smallint |
ID of the database in which the queue is defined. NULLABLE. |
queue_id |
int |
ID of the object of the queue for which the stored procedure was activated. NULLABLE. |
procedure_name |
nvarchar(650) |
Name of the activated stored procedure. NULLABLE. |
execute_as |
int |
ID of the user that the stored procedure runs as. NULLABLE. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Physical Joins
.gif "Joins for sys.dm_broker_activated_tasks")
Relationship Cardinalities
| From | To | Relationship |
|---|---|---|
dm_broker_activated_tasks.spid |
dm_exec_sessions.session_id |
One-to-one |
See Also
Reference
Dynamic Management Views and Functions
Service Broker Related Dynamic Management Views