title: How to send a HTTP or XML/RPC request from SQL Server stored procedure/trigger?
body: <p>my client has SQL Server with some customer info and I am developing e-shop using MySQL database. What we need is to keep the database of customer loyalty points synchronized. When customer buys a product in an ordinary shop (not e-shop) these are recorded on SQL Server (via some accounting app). The problem is that I need this information to get to the MySQL server which stores information for the e-shop application, so the amount of loyalty points gets sync'ed on both servers.</p>
  
  <p>Is there any way how can I send http and/or xml/rpc request from SQL Server via either trigger or stored procedure (I suppose trigger can trigger a stored procedure, so either of these is fine)?</p>