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

Service Broker sends and receives messages over the network while any endpoint for Service Broker is in the STARTED state. To resume Service Broker networking, alter the endpoints to set the state to STARTED.

ms166040.security(en-US,SQL.90).gifSecurity Note:
Activating Service Broker networking allows Service Broker to send and receive messages over the network. The authentication level set on the endpoint controls which network connections are accepted by the endpoint. For more information on Service Broker networking and security, see Service Broker Security Overview.

To resume Service Broker networking

  1. Alter an endpoint to set the state to STARTED.

Example

USE master ;
GO

ALTER ENDPOINT BrokerEndpoint
    STATE = STARTED ;
GO

See Also

Tasks

How to: Activate Service Broker Networking (Transact-SQL)
How to: Deactivate 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