How to Find Out if Service Broker is Enabled on a Database
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.