SQL Server Performance

How to see if Service Broker is enabled?

Discussion in 'SQL Server 2005 General DBA Questions' started by BikeBoy, Mar 25, 2008.

  1. BikeBoy New Member

    Hi all,
    How can I check if the Service Broker is enabled for a database or a server?
  2. ranjitjain New Member

    Hi,
    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 ;
    http://msdn2.microsoft.com/en-us/library/ms166086.aspx

Share This Page