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; ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
