MSSQL – Enabling “Service Broker protocol” for a DB

To determine whether or not Service Broker is enabled for a particular database, execute the following T-SQL:

SELECT is_broker_enabled FROM sys.databases WHERE name = ‘Database name’;

— Enable Service Broker:
ALTER DATABASE [Database Name] SET ENABLE_BROKER;

— Disable Service Broker:
ALTER DATABASE [Database Name] SET DISABLE_BROKER;

Database Mirroring will be enabled after installing  Service Pack 1 or later.

Written by actsupp-r0cks