calling webservice from sql server 2005 trigger

Question

Hi,

        I am using "HttpRuntime.Cache.Insert" to maintain the data set in the cache. The problem is that when new data is added to the data base table, I need to update data set which is in the cache.

For this I want to  call a webservice from the trigger to update the data set(cache). Can anyone help me that how to do that?

Thanks in advance

---

krishna

Answer 1

Hi krishna,

Please refer to the following links to call Web Services in SQL Server

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/2f553615-873c-49e3-b212-990ef1d3a89d/
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/b586e30f-37be-4bc5-9fe8-7efd06b31c18/
http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/eac9c027-db71-48ae-872d-381359d7fb51/

However, it’s not advisable to do so. Calling a Web Service from a trigger will slow down the performance, see:
http://sql-server-performance.com/Community/forums/p/2561/14584.aspx
 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.