How to Enable Service Broker in SQL server

SQL Server Service Broker

SQL Server Service Broker provides native support for messaging and queuing applications in the SQL Server Database Engine. This makes it easier for developers to create sophisticated applications that use the Database Engine components to communicate between disparate databases. Developers can use Service Broker to easily build distributed and reliable applications.

How to Check and  Enable Service Broker in SQL server

SELECT name, is_broker_enabled FROM sys.databases

- ALTER DATABASE myDatabase SET ENABLE_BROKER

or
ALTER DATABASE Database_Name SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;