I would call a webrequest from a trigger, it would keep the transaction open
too long. you should look at sqlservers service broker. in the trigger queue
a request to a service that does the web call. you can write this in the clr
language of your choice.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.