Activation and rollback

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 09 Jun 2006 00:27 GMT

When a transaction containing a receive command is rolled back 5 times, the
is_received_enabled is turned off. Is the magic number (5) for turning the
queue off configurable, and is there any way to monitor or reset that count?

Thanks,
Richard

Reply to this Message

Remus Rusanu [MSFT] - 09 Jun 2006 02:15 GMT

To monitor for poison message queue disabled events, subscribe to an event
notification for BROKER_QUEUE_DISABLED event on the given queue. See
http://msdn2.microsoft.com/en-us/library/ms189453.aspx for how to create and
event notification.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

HTH,
~ Remus Rusanu

SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx

> When a transaction containing a receive command is rolled back 5 times,
> the is_received_enabled is turned off. Is the magic number (5) for
[quoted text clipped - 3 lines]
> Thanks,
> Richard

Reply to this Message

Roger Wolter[MSFT] - 09 Jun 2006 04:11 GMT

No, it's not configuration. A event is fired when the queue goes not-ready.
The count is reset when a receive commits successfully.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

> When a transaction containing a receive command is rolled back 5 times,
> the is_received_enabled is turned off. Is the magic number (5) for
[quoted text clipped - 3 lines]
> Thanks,
> Richard

Reply to this Message