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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 call a web services

Author  Topic 

dipendra
Starting Member

2 Posts

Posted - 2008-09-09 : 02:05:18

hi

i want to know how to call a web services when trigger is fired.
if it is possible please add some sample code.

thanks

dipendra

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-09-09 : 10:17:05
that's a good way to bring the perf of your app to a screeching halt. why do you want to do this?


elsasoft.org
Go to Top of Page

dipendra
Starting Member

2 Posts

Posted - 2008-09-10 : 00:55:17
hi
thanks for the reply.
because my application need a real time change.
for eg.-
i have a page who display the current rate of the product.
and someone change the rate then my page refresh and show the latest rate.
so that is the reason i want to call the web services by trigger.

if you have any other solutions of my problem
then please tell me.
i m very thankfull to you.

thanks

dipendra
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-09-10 : 09:30:55
whoever changes the rate should call a proc that changes the rate. I don't see a need for a trigger here.


elsasoft.org
Go to Top of Page
   

- Advertisement -