Hi,

I'm glad my article inspired you to think of a service broker solution for your organisation. However this is only "lab session" code, so is not intended for production use. I encourage you to read up fully on the subject.

But in the meantime if you want to use the code sample I supplied, to play arround with some ideas of your own, then take a look at the "120 ManyConversations.sql" file. You will find code that loops through the system table names and uses them as parameters to the "uspInventoryCounts" stored procedure. Adapt this code to call your stored procedure and pass any parameters if required.