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.


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

Diagram of physical 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

Next steps

Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)