views:

25

answers:

1

Hi,

I want to implement a stored procedure (within a service broker infrasturture) which calls a web service. I looked some examples from Aschenbrenner's book on Service Broker. However I don't find any with a web service call. Could anyone help?

Thanks Sqlbs

A: 

See the first example in chapter 10. If your question is about details of implementing web service calls, please tag the question with appropriate web service tags rather than service broker.

Pawel Marciniak
Hi,Thank you for your notes.I looked at the example. It is about the calling of a web servie within the service broker infrastructure. What I really need is something like this:row inserted/updated to table -> insert/update trigger fires -> trigger writes message to service broker queue -> stored proc activated by SQL Server -> stored proc calls web service -> conversation ends. Any Idea?Sqlbs