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

Example System Design

The sample messaging system used in this chapter has the following design: An update stored procedure in AdventureWorks2012.Production.ProductModel starts up a service that initiates a conversation with a sister service in XCatMgmt. It does this by sending a message to XCatMgmt’s inbound work queue. When the transaction surrounding the initial send is complete, Service Broker transmits the message, signaling that a catalog update for an AdventureWorks Cycles product model is ready for processing.

In response to the arrival of this new message, Service Broker executes a stored procedure associated with a catalog maintenance service for XCatMgmt, known as its service program. This process is known as internal activation; ...

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