Managing Service Broker Conversations

December 9, 2009

SQL Server 2005’s Service Broker uses a new concept of a dialog conversation. Service Broker conversations are conceptually similar to T-SQL connections, but there are a few important differences that could affect performance, and even have the potential for data loss. I’ll discuss a few common pitfalls related to Service Broker conversation management and provide some simple solutions and workarounds.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=103131