sys.dm_broker_activated_tasks (Transact-SQL)

Applies to: SQL Server (all supported versions)

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.

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)