This topic has not yet been rated - Rate this topic

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

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005

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

Drop all Service Broker endpoints.

Example

USE master ;
GO

DROP ENDPOINT BrokerEndpoint ;
GO

Tasks

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

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

Reference

ALTER DATABASE (Transact-SQL)

ALTER ENDPOINT (Transact-SQL)

CREATE ENDPOINT (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD