Hi. I was wondering if anyone knows of a way of killing a long running instance of an activation procedure. Here is the scenario:
1. Many messages are queued on in same conversation to be processed by an Activation Procedure. The proc should take perhaps 1 second to execute.
2. In a heavily trafficked production window we had a occurence where an Activation Proc went into a very slow, long loop.
3. We were forced to use : select db_name(database_id),* from sys.dm_broker_activated_tasks (pick the correct task and...)
Kill 25
This killed all the messages queued in the conversation associated with the SPID. Anyone know of a way of ending an executing Activation Procedure with out killing all messages associated with a particular SPID?
thanks
Paul