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

1. 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).

2. Alter the endpoint to activate message forwarding, and specify the maximum size, in megabytes, for forwarded messages.

Example

USE master ;
GO

ALTER ENDPOINT BrokerEndpoint 
    FOR SERVICE_BROKER ( MESSAGE_FORWARDING = ENABLED,
                         MESSAGE_FORWARD_SIZE = 10 ) ;
GO

See Also

Tasks

How to: Activate Service Broker Networking (Transact-SQL)
How to: Deactivate Service Broker Message Forwarding (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance