Service Broker Tutorials

SQL Server Service Broker is used to create conversations for exchanging messages. Messages are exchanged between two ends: the target and initiator. Messages are used to transmit data, and to trigger processing when a message is received. The target and the initiator can be in the same database, different databases on the same instance of the Database Engine, or on separate instances. All tutorials are for users who are new to Service Broker. To start a tutorial, click one of the following links: 

Completing a Conversation in a Single Database.

Shows you how to create the objects that are required to support a simple conversation. Then, you start a conversation to send and receive messages.

Completing a Conversation Between Databases

Builds on the first Service Broker tutorial. It shows you how to extend a conversation between two databases in the same instance of the Database Engine.

Completing a Conversation Between Instances

Builds on the first Service Broker tutorial. It shows you how to extend a conversation between databases in separate instances of the Database Engine.

Implementing Internal Activation

Builds on the first Service Broker tutorial. It shows you how to create a stored procedure to receive messages from a queue, and use internal activation to run the stored procedure whenever there are messages in the queue.