Applies to: SQL Server (all supported versions)
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.