Error Handling for Service Broker

Error handling in an application that uses Service Broker has two distinct aspects. First, the application must handle errors raised by the 数据库引擎 through the normal Transact-SQL error mechanism. Second, an application that uses Service Broker must handle asynchronous errors that arrive as messages on the queue for the service. In either case, an application must not permanently remove a message from a queue without acting on the message, and the application must always hold a conversation group lock before updating state that is related to the conversation group.

In This Section

Topic Description

Handling Transact-SQL Errors (Service Broker)

Describes strategies for working with Transact-SQL errors while maintaining transactional messaging.

Handling Service Broker Error Messages

Describes strategies for handling error messages delivered by Service Broker.

Handling Poison Messages

Describes strategies for recovering from poison messages.

请参阅

其他资源

处理数据库引擎错误

帮助和信息

获取 SQL Server 2005 帮助