Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
Service Broker sends and receives messages over the network while any endpoint for Service Broker is in the STARTED state. To pause Service Broker networking, alter all Service Broker endpoints to set the state to STOPPED. Notice that this prevents Service Broker from transmitting messages out of the instance or receiving messages from outside of the instance, but does not affect message delivery within the instance. To prevent message delivery to a specific database, use ALTER DATABASE to deactivate Service Broker in that database.
To pause Service Broker networking
- Alter all Service Broker endpoints to set the state to STOPPED.
Example
USE master ;
GO
ALTER ENDPOINT BrokerEndpoint
STATE = STOPPED ;
GO
See Also
Tasks
How to: Deactivate Service Broker Networking (Transact-SQL)
How to: Resume Service Broker Networking (Transact-SQL)
Other Resources
ALTER DATABASE (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
CREATE ENDPOINT (Transact-SQL)