• Here is a query that will give output to help kill broker-activated tasks:

    SELECT

    'KILL ' + cast (at.spid as varchar)

    , at.spid

    , DB_NAME(at.database_id) AS [dbName]

    , at.queue_id

    , at.[procedure_name]

    , s.login_time

    , s.[status]

    FROM

    sys.dm_broker_activated_tasks at

    INNER JOIN

    sys.dm_exec_sessions s

    ON

    at.spid = s.session_id;

    Use this query when trying to kill conversations and unable to because you are being blocked by broker-activated sessions.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]