How to: Deactivate Service Broker Message Forwarding (Transact-SQL)
The document is archived and information here might be outdated

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.

  1. Alter the endpoint to deactivate message forwarding.

USE master ;
GO

ALTER ENDPOINT BrokerEndpoint 
    FOR SERVICE_BROKER ( MESSAGE_FORWARDING = DISABLED) ;
GO
Show:
© 2016 Microsoft