Re: Web Service from aspx

From: Alvin Bruney [MVP] (vapor)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 14:40:15 -0600

any module which can address a url can call into the webservice. otherwise
it can't. i'd hesitate to advise you to tie a trigger to a webservice as
that, to me, is tight coupling. A change in the webservice interface or
address will break the trigger which is not necessarily a good thing IMHO. 

-- 
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b
"RR" <anonymous@discussions.microsoft.com> wrote in message
news:E382049A-4197-43D6-8AE1-9F7AB7870ED3@microsoft.com...
> Hi,
> is it possible to call a web service from inside SQL Server in any way? If
yes, how?
>
> Basically I am trying to fire a insert trigger, which will select some
data from a table and instantiate .Net dll and populate its properties with
the table data. I know there are other ways to do it but i would like to
know if there is a way to achieve the above as well.
>
> Any help would be appreciated.
>
> Thanks,
> - Monideep
>