This topic has not yet been rated - Rate this topic

sys.dm_broker_activated_tasks (Transact-SQL)

SQL Server 2008 R2

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.

From	To	Relationship
dm_broker_activated_tasks.spid	dm_exec_sessions.session_id	One-to-one

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions