how to replay service broker messages : Poison Message handling

Question

Am using SQL Server Service Broker 2012.Am capturing the messages in the ServiceBrokerError table if there is any error while processing the Service Broker message.Now how can i reprocess the updated service broker message?

Answer 1

The below links helped me in resolving my actual Poison Message handling problem.As suggested By Serg

http://msdn.microsoft.com/en-us/library/ms171592.aspx,

http://www.mssqltips.com/sqlservertip/2309/sql-server-service-broker-poison-message-handling/

Thanks,

Ravi