MS SQL

How to Find Out if Service Broker is Enabled on a Database

Sal Young | May 26th, 2012

PROBLEM: I need to know if a database has Service Broker enabled.

SOLUTION: The query I have listed below will provide you with the information you are looking for and if a database master key has been created for a database.

SELECT name [DatabaseName]
     , is_broker_enabled [IsServiceBrokerEnabled]
     , is_master_key_encrypted_by_server [HasDatabaseMasterKey]
  FROM sys.databases
 WHERE is_broker_enabled = 1
»
«

One Reply to “How to Find Out if Service Broker is Enabled on a Database”

  • Hey there just wanted to give you a quick heads up.
    The words in your post seem to be running off the screen in Ie.
    I’m not sure if this is a formatting issue or something to do with web
    browser compatibility but I figured I’d post to let
    you know. The style and design look great though! Hope you get the problem solved soon. Cheers

Leave a Reply