Sample Header Ad - 728x90

Service Broker: Queue Monitor is dropped after poison message

8 votes
1 answer
2342 views
I have searched everywhere and there isn't an answer online. There is one similar question on stackoverflow but it's not exactly the same and it has no accepted answer. When I setup event notification on a queue, it creates a queue monitor and if receiving a message from that queue causes a poison message the queue monitor disappears. It's not in "RECEIVE" or "INACTIVE" it's just drops. And after enabling the queue with ALTER QUEUE somequeue WITH STATUS = ON; the queue monitor does not re-appear and and I need to drop and recreate event notification in order to have event notification working again. So the question is, is that by design or not? And after I re-enable the queue after poison message is it a common practice to recreate event notifications. Thanks!
Asked by Sergey (131 rep)
Jul 19, 2012, 09:39 PM
Last activity: Jul 18, 2025, 10:04 PM