What happens when you end a Sql Server Service Broker message "with error"? -
i trying figure out how deal errors using sql server service broker.
i have read there no real "poison message" control in service bus other stop processing.
for system, bad (we quite behind on messages).
i have seen example says deals using end conversation error <error code>
but can't seem find out in queues or error recorded.
if knows calling "with error" on end conversation does, love hear it.
it places error message on queue rather enddialog message. books online states 'service broker drops other messages conversation in transmission queue.' take mean message replaces messages haven't yet been sent.
the error number , message placed in message body.
Comments
Post a Comment