how can a sql server consume a web service

I am trying to figure out how I can have SQL server consume a web
service.
Thanks for your help.
SimoneHi Simone
SQL Server 2005 can provide you with a XML Web Service, this is documented
in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx or
http://msdn2.microsoft.com/en-us/library/ms191274.aspx
If you want to store information from an RSS feed in your database you may
want to check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp.
With SQL 2005 the CLR could be used to do this and there is an example in
"Pro SQL Server 2005" by Thomas Rizzo et al.
ISBN 1-59059-477-0
John
"Simone" wrote:
> I am trying to figure out how I can have SQL server consume a web
> service.
> Thanks for your help.
> Simone
>|||Hello Thanks for your reply.
We need this for SQL server 2000 and I tried to search at the Microsoft
website but I couldn't find.
Can you help me finding information for this but for SQL server 2000?
Thanks
Simone
John Bell wrote:
> Hi Simone
> SQL Server 2005 can provide you with a XML Web Service, this is documented
> in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx or
> http://msdn2.microsoft.com/en-us/library/ms191274.aspx
> If you want to store information from an RSS feed in your database you may
> want to check out
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp.
> With SQL 2005 the CLR could be used to do this and there is an example in
> "Pro SQL Server 2005" by Thomas Rizzo et al.
> ISBN 1-59059-477-0
> John
> "Simone" wrote:
> > I am trying to figure out how I can have SQL server consume a web
> > service.
> >
> > Thanks for your help.
> > Simone
> >
> >|||Hi Simone
The ability to provide a HTTP endpoint directly in SQL Server is only
available in SQL 2005, with SQL 2000 you would need to use something like
IIS. The XML to SQL example
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp will work for SQL 2000 if you download SQLXML SP2 or higher.
John
"Simone" wrote:
> Hello Thanks for your reply.
> We need this for SQL server 2000 and I tried to search at the Microsoft
> website but I couldn't find.
> Can you help me finding information for this but for SQL server 2000?
> Thanks
> Simone
> John Bell wrote:
> > Hi Simone
> >
> > SQL Server 2005 can provide you with a XML Web Service, this is documented
> > in Books Online see http://msdn2.microsoft.com/en-us/library/ms345123.aspx or
> > http://msdn2.microsoft.com/en-us/library/ms191274.aspx
> >
> > If you want to store information from an RSS feed in your database you may
> > want to check out
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp.
> > With SQL 2005 the CLR could be used to do this and there is an example in
> > "Pro SQL Server 2005" by Thomas Rizzo et al.
> > ISBN 1-59059-477-0
> >
> > John
> >
> > "Simone" wrote:
> >
> > > I am trying to figure out how I can have SQL server consume a web
> > > service.
> > >
> > > Thanks for your help.
> > > Simone
> > >
> > >
>