Calling a webservice from a SQL Trigger

Please,
is there a way i can execute a webservice from within a SQL Server 2k
Trigger? Sending and receiving XML values?
Tks,
Fabiano
Hi
Maybe you can do this through a COM object and the sp_OA* procedures?
John
"Fabiano" <a@.a.com.br> wrote in message
news:%23WqHeXqlEHA.1644@.tk2msftngp13.phx.gbl...
> Please,
> is there a way i can execute a webservice from within a SQL Server 2k
> Trigger? Sending and receiving XML values?
> Tks,
> Fabiano
>
>

Caliing a webservice from a trigger

Please,
is there a way i can execute a webservice from within a SQL Server 2k
Trigger? Sending and receiving XML values?
Tks,
Fabiano
This is not directly supported or recommended.
You probably could write your own custom code using an extended stored proc
or using sp_OA stored procs.
Best regards
Michael
"Fabiano" <a@.a.com.br> wrote in message
news:%23CzqpXqlEHA.1244@.TK2MSFTNGP15.phx.gbl...
> Please,
> is there a way i can execute a webservice from within a SQL Server 2k
> Trigger? Sending and receiving XML values?
> Tks,
> Fabiano
>
>