Clearing errored messages from sys.transmission

Clearing errored messages from sys.transmission_queue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom Wilson - 08 Mar 2006 19:47 GMT

Following up on my previous post - now that I've got queues working, there
are still the old errored-out messages in sys.tranmission_queue. Is there
an official way of clearing these out?

Reply to this Message

Kent Tegels - 08 Mar 2006 20:22 GMT

Hello Tom,

> Following up on my previous post - now that I've got queues working,
> there are still the old errored-out messages in sys.tranmission_queue.
> Is there an official way of clearing these out?

Issue END CONVERSATION for their handles.

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Reply to this Message

Remus Rusanu [MSFT] - 08 Mar 2006 20:25 GMT

END CONVERSATION @dh WITH CLEANUP

You can issue this even for closed/errored conversations, it will remove
anything left from of the conversation.
See also this post:
http://blogs.msdn.com/remusrusanu/archive/2006/01/27/518455.aspx on the
dangers of abusing this.

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

> Following up on my previous post - now that I've got queues working, there
> are still the old errored-out messages in sys.tranmission_queue. Is there
> an official way of clearing these out?

Reply to this Message