Sample Dialog

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

Get Inside Microsoft® SQL Server™ 2005 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.