SQL Server service broker-Message Queue

SQL Server service broker- Message Queue Service broker is a message service integrated in SQL Server 2005/2008, allowing database applications Program One-way or two-way message exchange is easy. Two important advantages of service broker are: (1) asynchronous messages (2) ensure that the service broker at the destination contains some related components, contract, service, queue, Message Type message type, service program or service application (generally stored procedure), and so on, as shown in.
The Service Broker application communicates with each other through a dialog. In real life, conversations are communication between two people. One person sends a message, and the other person receives the message and replies. In service broker, a dialog is a reliable and asynchronous message exchange through contract, queue, and service. In short, a service broker dialog is used to send and receive messages. As shown in, two separated databases define a Service Broker Service, which sends and receives messages to each other for two-way conversations.
The Orders database sends a message to the shipping database, indicating that an order has been received and confirmed. The shipping database sends a confirmation message, indicating that the order is being processed. Then, when the order is actually delivered, another message is sent to the Orders database. When a message enters the queue, you can configure the service broker to automatically start the service program, or configure the program to regularly check the message queue ). The service broker is flexible enough to meet different business needs. We recommend that you refer to the following for actual service broker development: Article : Service Broker implement publish-subscription (publish-subscribe) Framework (1) (Chinese) http://forum.entlib.com/Default.aspx? G = posts & t = 70 service broker implement publish-subscription (publish-subscribe) Framework (2) (Chinese) http://forum.entlib.com/Default.aspx? G = posts & t = 71 service broker implement publish-subscription (publish-subscribe) Framework (3) (Chinese) http://forum.entlib.com/Default.aspx? G = posts & t = 72 introducing distributed messaging using service broker in SQL Server 2005 http://www.codeproject.com/KB/database/IntroServiceBroker.aspx