Service Broker

Question

What is Service Broker?

Jignesh Trivedi · Answer

hi, Service Broker is a new feature in SQL Server 2005 that brings queuing and reliable messaging to SQL Server. Service Broker provides the "plumbing" to let you pass messages between applications, using SQL Server as the transport mechanism. Applications can use a single shared SQL Server database for this purpose or distribute their work across multiple databases. Service Broker handles all of the details of message passing, including: * locking * retries * rejecting ill-formed messages * ensuring "exactly once in-order" (EOIO) delivery hope this help.

Satyapriya Nayak · Answer

Hi Stelia, Normal 0 Service Broker helps developers build asynchronous, loosely coupled applications in which independent components work together to accomplish a task. These application components exchange messages that contain the information that is required to complete the task. This topic describes the following aspects of Service Broker: Conversations Message ordering and coordination Transactional asynchronous programming Support for loosely coupled applications Service Broker components Please refer the below link http://sqlblog.com/blogs/allen_white/archive/2010/01/06/service-broker-basics.aspx http://msdn.microsoft.com/en-us/library/ms166049.aspx Thanks