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

Setting Up Contracts for Communication

You use contracts to specify which messages can flow from which endpoints to which queues. Two T-SQL keywords come into play here:

Image INITIATOR—This service begins a messaging conversion.

Image TARGET—This service engages in (or accepts) conversions with an initiator.

As described earlier, the sample system is initiated by a stored procedure in AdventureWorks2012 that sends a message of type CatalogChangeMessage to a queue in XCatMgmt. Every CatalogChangeMessage is thus sent by a conversation initiator.

The catalog ...

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