First published on MSDN on Jun 30, 2008
Service broker provides automatic poison message detection, which disables the service queue upon five consecutive transaction rollb...
Updated Mar 23, 2019
Version 2.0
Blog Post
What is the way to disable the Service broker Queue dynamically .I dont want to use below query as when we have event notification is set ,events wont be triggered when we manually disable the queue
EXEC ServiceBroker.Queue_SetStatus 'QueueName', 'OFF'
I have created a stored procedure which will automatically enable the SB queue.
Created the Queue ,service(http://schemas.microsoft.com/SQL/Notifications/PostEventNotification) ,Activation Procedure which is custom one i have written, and Event notification on created queue FOR BROKER_QUEUE_DISABLED
Now i want to test the same.But somehow i am not able to disable the SB queue by sending poison message
Can some one help