Microsoft® SQL Server 2008 R2 Unleashed

Defining Services to Send and Receive Messages

Services represent the endpoints in Service Broker applications. You can think of them as the glue that binds contracts with queues. This binding ensures that the typed messages specified in the contract end up in the appropriate queues.

Here is the DDL syntax for creating services:

For this example, you need to create two services: the initiator in AdventureWorks2008 and the target in XCatMgmt.

This is the initiator in AdventureWorks2008:

And this is the target in XCatMgmt:

As you can see, creating ...