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