I have to solve the following task:
After Inserting/Updating/Deleting records I have to call a web service to exchange data with an external location. 1. The synchrone way: I implement as stored procedure which call the web service and call the stored procedure from the trigger. 2. Something does not work. I have to place all inserted/updated/deleted records to a temp-Table and call via a windows service (interval 5 minutes) asynchronely the web service to transfer the data.
Questions: 1. Do trigger influence the perfomance? 2. What is the best solution to the second task? Can I use service broker to do the job?
Best regards, B.S.