Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Returns a row for each stored procedure activated by Service Broker.
| Column name | Data type | Nullable | Description |
|---|---|---|---|
spid |
int | Yes | ID of the session of the activated stored procedure. |
database_id |
smallint | Yes | ID of the database in which the queue is defined. |
queue_id |
int | Yes | ID of the object of the queue for which the stored procedure was activated. |
procedure_name |
nvarchar(325) | Yes | Name of the activated stored procedure. |
execute_as |
int | Yes | ID of the user that the stored procedure runs as. |
Permissions
SQL Server 2019 (15.x) and previous versions require VIEW SERVER STATE permission on the server.
SQL Server 2022 (16.x) and later versions require 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 |