Microsoft® SQL Server 2012 Unleashed

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; ...