Posted by Plamen Ratchev on 12/26/07 20:20

In SQL Server 2005 you can use HTTP endpoints to expose stored procedures or
user defined functions as Web methods. Here are a couple good articles that
describe that:
http://www.developer.com/db/article.php/3390241
http://www.devx.com/dbzone/Article/28525

However, seems you need to consume a Web service within a stored procedure,
not to expose. This can be accomplished in SQL Server 2005 via CLR (Common
Language Runtime). The articles below will show you examples of doing that:
http://www.simple-talk.com/sql/sql-server-2005/practical-sql-server-2005-clr-assemblies/
http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx
http://blogs.msdn.com/sqlclr/archive/2005/07/25/Vineet.aspx

Although doable, SQL Server may not be the best place to make Web service
calls. Perhaps having an external application that makes the call and passes
results to SQL Server will be a better architecture.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Format Number on Select
• Prev in forum: Re: Format Number on Select
• Thread view: Re: SQL Server 2005 and Geo Web Services

[Reply to this message]