Posted by Lauren Quantrell on 12/27/07 05:03

Plamen,
Thanks for the response. These links are exactly what I was looking
for. I have an Access front end so I'm looking for a solution that
will not require a seperate dot.net application to call the web
service.
lq

On Dec 26, 3:20 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> 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/3390241http://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-2...http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspxhttp://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 Ratchevhttp://www.SQLStudio.com

[Back to original message]