Klaus Aschenbrenner is following up on his Pro SQL Server 2005 Service Broker book with an update for 2008. The book is already available for pre-order on Amazon: http://www.amazon.com/Pro-Server-2008-Service-Broker/dp/1590599993 and will contain a troubleshooting and administration chapter writen by yours truly
This article is a continuation of my two articles on using Service Broker as a pure data-push one-way communication channel: Reusing Conversations and Recycling Conversations. I originally did not plan for this third part, but I was more than once asked the same question: if a conversation is in error what happens to the messages that were sent but not yet delivered?
The short answer is that messages that are still pending are in the sender’s database sys.transmission_queue system table so when an Error message is received the sender can scan this table and resend each message that is still pending. An example of such procedure is not difficult to code:
I will attend tomorrow, December 4, the Data Mining and Business Intelligence for Enterprises event in Bucharest thanks to an invitation from my friend the SQL Server MVP Cristian Lefter. Now I know that most readers of this blog will not be in Romania 🙂 but I thought to post this case you happen to be there and want to have a Service Broker chat or just want to meet me and say Hi!