Discussion in 'SQL Server 2005 General DBA Questions' started by BikeBoy, Mar 25, 2008.
How can I check if the Service Broker is enabled for a database or a server?
Refer to this MSDN article which says that By default, Service Broker message delivery is active in a database when the database is created. To determine if Service Broker is active for a database, check the is_broker_enabled column of the sys.databases catalog view.
To activate Service Broker in a database: ALTER DATABASE AdventureWorks SET ENABLE_BROKER ;
Separate names with a comma.