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

[Back to original message]