O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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:

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required