Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
From | To | Relationship |
---|---|---|
dm_broker_activated_tasks .spid |
dm_exec_sessions .session_id |
One-to-one |
Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register today