How to: Deactivate Service Broker Message Forwarding (Transact-SQL)
Message forwarding allows an instance of SQL Server to accept messages from outside the instance and send those messages to a different instance. Message forwarding is configured on a Service Broker endpoint.
To deactivate Service Broker message forwarding
- Alter the endpoint to deactivate message forwarding.
USE master ; GO ALTER ENDPOINT BrokerEndpoint FOR SERVICE_BROKER ( MESSAGE_FORWARDING = DISABLED) ; GO