sys.dm_broker_activated_tasks (Transact-SQL)
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. |
