In this section, I’ll present a simple Service Broker application that demonstrates how all this fits together. I’ll start with an application that runs in a single database and, in subsequent sections, show how to move this application into a distributed environment.
The application to be built is an inventory application that accepts items from a manufacturing application and adds them to inventory. To simplify the code, it will be completely implemented as T-SQL stored procedures. In reality, one or more of the services would probably be either an external application connecting to the database or a CLR stored procedure.
A stored procedure called AddItemProc will send a message to the InventoryService with an XML body that contains ...