Queue not disabling

HI There

My activated proc is rolling back the transaction and putting the message abck on the queue infinately ?

Normally it disabled the queue after a few rollbacks, i can see in the sql log that it just keeps rolling back and re-activating thousands of times.

It only stops when i disable activation on the queue.

WHy is the queue not disabling ?

Thanx

Did you look at sys.service_queues to see if the queue is really disabled? Does profiler show the queue_disabled event?|||

Thanx Rushi

Thats what i thought just wanted to check Thanx

|||

Sorry that comment was on the wrong post, yes i check sys.service_queues to make sure it is enabled. ANd i check the sql log and can see the activated sp activating and rolling abck thousands of times until i disable actiavtion. I find it very strange it always used to disable becuase of the poison message, but no longer not sure why, i would not even know how to disable poison messages?

Thanx

Queue activation context

Is there any way to identify the context by which a stored proc has been activated. i.e.

I want to use the same sp to end conversations on receipt of the end mesage from the target.

However I don't know how to find out which queue activated the SP.

See this previous thread on the topic: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=752317&SiteID=1

HTH,
~ Remus

Queue activation context

Is there any way to identify the context by which a stored proc has been activated. i.e.

I want to use the same sp to end conversations on receipt of the end mesage from the target.

However I don't know how to find out which queue activated the SP.

See this previous thread on the topic: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=752317&SiteID=1

HTH,
~ Remus