How to: Pause Service Broker Networking (Transact-SQL)
Service Broker sends and receives messages over the network while any endpoint for Service Broker is in the STARTED state. To pause Service Broker networking, alter all Service Broker endpoints to set the state to STOPPED. Notice that this prevents Service Broker from transmitting messages out of the instance or receiving messages from outside of the instance, but does not affect message delivery within the instance. To prevent message delivery to a specific database, use ALTER DATABASE to deactivate Service Broker in that database.
To pause Service Broker networking
- Alter all Service Broker endpoints to set the state to STOPPED.
USE master ; GO ALTER ENDPOINT BrokerEndpoint STATE = STOPPED ; GO