Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 Call web services from SQL Server

Author  Topic 

rajk
Starting Member

20 Posts

Posted - 2004-05-03 : 07:26:10
Hi,
I have a situation where I need to call a web service from the database (by an insert trigger on a table). Please let me know how I could do this.
Thanks in advance
Raj

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-05-04 : 21:38:03
A trigger most likely will be very inefficient for this type of messaging. Another option might be to create a windows service which monitors the table, or some message brokering queue (ie MSMQ), which performs the call to the web service.
Go to Top of Page
   

- Advertisement -