How to: Activate 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 activate Service Broker message forwarding
Activate Service Broker networking if networking is not already active. For more information on Service Broker networking, see How to: Activate Service Broker Networking (Transact-SQL).
Alter the endpoint to activate message forwarding, and specify the maximum size, in megabytes, for forwarded messages.
USE master ; GO ALTER ENDPOINT BrokerEndpoint FOR SERVICE_BROKER ( MESSAGE_FORWARDING = ENABLED, MESSAGE_FORWARD_SIZE = 10 ) ; GO