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.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)