Microsoft® SQL Server 2012 Unleashed

Defining Services to Send and Receive Messages

Services represent endpoints in Service Broker applications. You can think of them as the glue that binds contracts to 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:

Click here to view code image

CREATE SERVICE ServiceName[AUTHORIZATION OwnerName]ON QUEUE [SchemaName.]QueueName[( ContractName | [ DEFAULT ] [ ,...n ] )] [;]

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

This is the initiator in AdventureWorks2012:

Click here to view code image

USE AdventureWorks2012GOCREATE SERVICE[//samspublishing.com/SS2012/SSB/Services/CatalogChangeInitiatorService] ...