sys.dm_broker_activated_tasks (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row for each stored procedure activated by Service Broker.

Column nameData typeDescription
spidintID of the session of the activated stored procedure. NULLABLE.
database_idsmallintID of the database in which the queue is defined. NULLABLE.
queue_idintID of the object of the queue for which the stored procedure was activated. NULLABLE.
procedure_namenvarchar(650)Name of the activated stored procedure. NULLABLE.
execute_asintID of the user that the stored procedure runs as. NULLABLE.

Requires VIEW SERVER STATE permission on the server.

Joins for sys.dm_broker_activated_tasks


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

Community Additions