Problem with service broker where it will stop processing messages. here are the Symptoms
Initiator Queue is empty Target Queue is empty Sys.conversation_endpoints shows messages with state = CO
I have tried to restart the process by toggling the queue off and then on again but the conversations will not finish.
asked Jun 03 '10 at 10:47 AM in Default
Attended my local SSUG meeting last night, and we had a great session on Service Broker from Anthony Brown.
Some great resources came out of that, that might be of some use
Remus Rusanu (pretty much built Service Broker) Blog/website has A LOT of Service Broker content, especially, [Troubleshooting guides]: http://rusanu.com/2005/12/20/troubleshooting-dialogs/
answered Aug 06 '10 at 01:27 AM
Kev Riley ♦♦