"preeth" <anonymous@discussions.microsoft.com> wrote in message
news:1a5f301c41def$553655b0$a501280a@phx.gbl...
> Hi,
>
> can anybody please tell wheather it is possible to invoke
> an URL from a Job/Trigger/stored procedure.
>
> thanks in advance,
> preeth

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:%23QO4PafHEHA.3700@TK2MSFTNGP09.phx.gbl...
> Well, you could shell out to call a VBScript file that uses XMLHTTP, or
use
> sp_OACreate to create XMLHTTP directly. Not something I would want to do
in
> a trigger however, as there is a significant performance hit, elevated
> permissions requirements, and the possibility of memory leaks. Can you
have
> the calling application take care of this portion instead?
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
>
>
> "preeth" <anonymous@discussions.microsoft.com> wrote in message
> news:1a5f301c41def$553655b0$a501280a@phx.gbl...
> > Hi,
> >
> > can anybody please tell wheather it is possible to invoke
> > an URL from a Job/Trigger/stored procedure.
> >
> > thanks in advance,
> > preeth
>
>

"Christian Perthen" <someone@nospamthankyou.com> wrote in message
news:OxfZ0tMIEHA.3664@TK2MSFTNGP11.phx.gbl...
> Interesting question.
> And how do you shell out a call to a VBScript file from a SP?
>
> Thanks
> Christian Perthen
>
>
> "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> news:%23QO4PafHEHA.3700@TK2MSFTNGP09.phx.gbl...
>> Well, you could shell out to call a VBScript file that uses XMLHTTP, or
> use
>> sp_OACreate to create XMLHTTP directly. Not something I would want to do
> in
>> a trigger however, as there is a significant performance hit, elevated
>> permissions requirements, and the possibility of memory leaks. Can you
> have
>> the calling application take care of this portion instead?
>>
>> --
>> Aaron Bertrand
>> SQL Server MVP
>> http://www.aspfaq.com/
>>
>>
>>
>>
>> "preeth" <anonymous@discussions.microsoft.com> wrote in message
>> news:1a5f301c41def$553655b0$a501280a@phx.gbl...
>> > Hi,
>> >
>> > can anybody please tell wheather it is possible to invoke
>> > an URL from a Job/Trigger/stored procedure.
>> >
>> > thanks in advance,
>> > preeth
>>
>>
>
>