sys.dm_broker_activated_tasks (Transact-SQL)
Applies to: 
SQL Server
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.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Physical joins
Relationship cardinalities
| From | To | Relationship |
|---|---|---|
dm_broker_activated_tasks.spid |
dm_exec_sessions.session_id |
One-to-one |
Next steps
Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)