How to enable service broker for specified database?

Hi All,

I am newbie in SQL Service broker. As we know, the is_broker_enabled can help us check whether the specified database is enabled for service broker. I would like to know

<>How can I enable servce broker for specified database if I see the value(is_broker_enabled) is 0?

<>How can I disable the service broker for specified database is I see the vlaue (is_broker_enabled) is 1? Do I need to dropped all service broker configration in the specified database?

Thanks in advance.

Michael

ALTER DATABASE test SET ENABLE_BROKER

ALTER DATABASE test SET DISABLE_BROKER

This temporarily shuts down the Service Broker operations in the database - you can enable and disable it as often as you want whether there are service broker objects in the database or not.