How to enable, disable and check if Service Broker is enabled on all sql databases

To check if Service Broker is enabled or disabled on your databases: SELECT [name],[is_broker_enabled],[service_broker_guid] FROM [sys].[databases] To enable Service Broker run the below SQL query: ALTER DATABASE [Database_name] SET ENABLE_BROKER WITH rollback immediate; To disable Service Broker run the below SQL query: ALTER DATABASE [Database_name] SET DISABLE_BROKER WITH rollback immediate;   PS: Replace [Database_name] with your Database name before running your query.