MS-SQL Push처리 기능 Service Broker 사용하기

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