I want to capture the event when a row in a table is updated and send selected items from that row in an XML format to a HTTP interface.
My thinking of how to capture the event would be either a trigger on the table or having a separateÃÂ application which maybe running on another server capture the event. If I used a trigger how do I format the selected items from the table into an XML format and send it to a HTTP interface? If I used a separate application which could be a WCF Service then how do I subscribe to the table update event as to format into XML and send to a HTTP interface is straight forward.
My preference would be to use a WCF Service as it seems to me this is more flexible and I don't have to deploy anything on the SQL Server.
View Complete Post