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

1. Alter the endpoint to deactivate message forwarding.

Example

USE master ;
GO

ALTER ENDPOINT BrokerEndpoint 
    FOR SERVICE_BROKER ( MESSAGE_FORWARDING = DISABLED) ;
GO

See Also

Tasks

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

Help and Information

Getting SQL Server 2005 Assistance