Microsoft® SQL Server™ 2005 Administrator's Companion

Managing Service Broker Applications

From time to time, you’ll need to perform maintenance on Service Broker applications. In this section, we’ll review the more commonly used commands for managing your applications.

Stopping a Service Broker Application

When you stop a Service Broker application, the application prevents initiator applications from sending messages to the queue and target applications from receiving messages from the queue. You might need to do this when you need to make updates to the applications or to an activation stored procedures used by the application. Target applications that attempt to receive a message from the queue receive an error message. Incoming messages to the queue are held in the database transmission queue ...