Consume C#.net web service through sql server store proc

Question

can any one explain how to Consume C#.net web service through sql server store procedure . regards Gaurav Tripathi

Jignesh Trivedi · Answer

Hi Please refer below link it might help you. http://fawadaziz.blogspot.in/2013/06/call-web-services-from-sql-stored.html http://www.vishalseth.com/post/2009/12/22/Call-a-webservice-from-TSQL-(Stored-Procedure)-using-MSXML.aspx http://blog.hoegaerden.be/2008/11/11/calling-a-web-service-from-sql-server-2005/

Prasham Sabadra · Answer

Hi Gaurav Please check following link once http://www.codeproject.com/Articles/428200/How-to-invoke-a-Web-Service-from-a-Stored-Procedur

gaurav · Answer

thanks for your answer and it is working fine but when call svc service(wcf service) it generate the error 500 internal server error post  please provide the solution