I am working on banking project. For migration purpose, I will call web service in store procedure and based on this response I will process another task. Create a Procedure named WebserviceCall CREATE procedure WebserviceCall @ UsrID as varchar ( 50 ) , @ Password AS Varchar ( 50 ) , @ AccountNo AS Varchar ( 50 ) AS BEGIN DECLARE @ obj INT DECLARE @ ValorDeRegreso INT DECLARE @ sUrl VARCHAR ( 200 ) DECLARE @ response VARCHAR ( 8000 ) = 'Failed' DECLARE @ hr INT DECLARE @ src VARCHAR ( 255 ) DECLARE @ desc VARCHAR ( 255 ) BEGIN TRY SET @ sUrl = 'http://x.x.x.x/mtcwebservicetest/Service.asmx/GetSession?UserID=' +@ UsrID + '&Password=' +@ Password + '' ; EXEC sp_OACreate 'MSXML2.ServerXMLHttp' , @ obj out EXEC sp_OAMethod @ obj, 'open' , NULL , 'GET' , @ sUrl, false EXEC sp_OAMethod @ obj, 'send' --EXEC sp_OAGetProperty @obj,'responseText',@response out ...