Featured Database Articles

Managing Service Broker Conversations

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.