1. Service Broker 활성화
ALTER DATABASE MyDatabase
SET ENABLE_BROKER
WITH ROLLBACK IMMEDIATE
GO
SELECT is_broker_enabled FROM sys.databases WHERE name = 'MyDatabase'
출처: https://stackoverflow.com/questions/29172828/can-i-turn-on-service-broker-on-all-my-databases