Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation”. Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered to be a dialog where two participants are involved.
--Enable Service Broker
ALTER DATABASE DB_Name SET ENABLE_BROKER;
--Verify status of Service Broker. A status of 1 means that it is enabled (0 means it is disabled)
SELECT is_broker_enabled
FROM sys.databases
WHERE name = 'DB_Name'
