title: what's the best practice for calling a webservice from within a trigger (SQL Server)
body: <p>I have need to call a webservice when a particular column in a table changes. I can handle the deciding of which column changed in the insert/update/delete but I'm not sure how I should call the webservice. </p>
  
  <p>The webservice is offsite, we have a little control over it (we can ask for changes and get a reasonably quick response) but the service is a work in progress and so is our code. </p>
  
  <p>SQL Server version is 2005. </p>
  
  <p><strong>Update</strong>: much of the business logic in this app is in the SQL layer. No way for me to change it and complaining about it is not a good use of my time. It is what it is. Wish that there was a business logic layer but it's partially in the pres layer and partially in the SQL layer. A trigger in the table is the most central place. </p>