Condividi tramite


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 Motore di database 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.

Vedere anche

Altre risorse

Gestione degli errori del Motore di database

Guida in linea e informazioni

Assistenza su SQL Server 2005