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

  1. Alter all Service Broker endpoints to set the state to STOPPED.

Example

USE master ;
GO

ALTER ENDPOINT BrokerEndpoint
    STATE = STOPPED ;
GO

See Also

Tasks

How to: Deactivate Service Broker Networking (Transact-SQL)
How to: Resume Service Broker Networking (Transact-SQL)

Other Resources

ALTER DATABASE (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
CREATE ENDPOINT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance