Export (0) Print
Expand All
0 out of 5 rated this helpful - Rate this topic

How to: Activate Service Broker Message Delivery in Databases (Transact-SQL)

By default, Service Broker message delivery is active in a database when the database is created. When message delivery is not active, messages remain in the transmission queue. To determine if Service Broker is active for a database, check the is_broker_enabled column of the sys.databases catalog view.

ms166086.security(en-US,SQL.90).gifSecurity Note:
Activating Service Broker allows messages to be delivered to the database. A Service Broker endpoint must be created to send and receive messages from outside of the instance.

  1. Alter the database to set the ENABLE_BROKER option.

USE master ;
GO

ALTER DATABASE AdventureWorks SET ENABLE_BROKER ;
GO
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.