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

Service Broker sends and receives messages over the network while any Service Broker endpoint is in the STARTED state. To deactivate Service Broker networking, drop all Service Broker endpoints.

To deactivate Service Broker networking

  1. Drop all Service Broker endpoints.

Example

USE master ;
GO

DROP ENDPOINT BrokerEndpoint ;
GO

See Also

Tasks

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

Other Resources

ALTER DATABASE (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
CREATE ENDPOINT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance