Free Training and Career help

The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker. The Transact SQL Data Manipulation Language is used to the send messages to a queue in the database of the sender or to another database in the SQL Server instance, or another server instance or remote server. Conceptually the process involves queues, dialogs, conversations groups and activation. In this tutorial we will briefly examines these concepts before having a practical look at what happens when messages are sent or received by the service broker.

The Service Broker consists of a number of SQL Server objects that represent the various components of the asynchronous messaging system. A service is a set of tasks that is available, while message types represent the messages exchanged to complete a task. The messages are held in a queue and these messages are processed at predefined intervals and sent. Once the message has been sent, the application updates the data to indicate that the message has been sent.

To facilitate this process, a number of additions have been made to SQL Server database. Message types, queues, services, contracts and conversations have been added to create the various capacities of the Service Broker.

Read More...

http://www.exforsys.com/content/view/1712/356/