question

EXEC @hResult = sp_OACreate 'MSXML2.ServerXMLHTTP', @objectID OUT -- open the destination URI with Specified method EXEC @hResult = sp_OAMethod @objectID, 'open', null, @methodName, @URI, 'false' EXEC @hResult = sp_OAMethod @objectID, 'send',null IF @hResult <> 0 BEGIN EXEC sp_OAGetErrorInfo @objectID, @source OUT, @desc OUT SELECT hResult = convert(varbinary(4), @hResult), source = @source, description = @desc, FailPoint = 'Send failed', MedthodName = @methodName goto destroy return END declare @statusText varchar(1000), @status varchar(1000) -- Get status text exec sp_OAGetProperty @objectID, 'StatusText', @statusText out exec sp_OAGetProperty @objectID, 'Status', @status out select @status, @statusText, @methodName -- Get response text exec sp_OAGetProperty @objectID, 'responseText', @responseText out exec sp_OADestroy @objectID i configured sp_configure and olemethods also this was working fine in local mechine but my remote sql server it was not working and giving null response.please help me for this issue otherwise suggest me for any other way to do this. And am getting Error:0x80072EE(The server name or address could not be resolved)please help me out to solve this problem in remote server.