Soap Web Service Calls from SQL Server

Question

I'm not entirely sure if this is possible, but does anyone know how, or if you can make calls to a SOAP web service from SQL Server? Seems like it might be good performance-wise in the area of data sync applications. I feel like this might be a long shot though.

Thanks.

Answer 1

If you're using SQL Server 2005 or higher, you can call a Web service by creating a CLR Procedure that does the task.

Answer 2

Creating a CLR based call is pretty tedious and not really recommended. why do you want to do this? maybe we can provide another option.

Answer 3

You may want to refer to this stackoverflow question: SQL Server - Using CLR integration to consume a Web Service