Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

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

SQL Server 2005

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

Copy 
USE master ;
GO

ALTER ENDPOINT BrokerEndpoint 
    FOR SERVICE_BROKER ( MESSAGE_FORWARDING = ENABLED,
                         MESSAGE_FORWARD_SIZE = 10 ) ;
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.