declare @sConnectionString varchar(150) = 'Provider=SQLOLEDB;Server=(local);Database=test;Integrated Security=SSPI;'
declare
		@cn int,
		@rs int,
		@hResult int,
		@sErrorSource varchar(255),
		@sErrorDesc varchar(255),
		@sSQL varchar(255),
		@xmlDoc int,
		@rsState int

declare @t table (id int identity, xml_data xml)

--	**********************************
exec @hResult = sp_OACreate 'ADODB.Connection', @cn out;
exec @hResult = sp_OAMethod @cn, 'Open', null, @sConnectionString;

exec @hResult = sp_OACreate 'MSXML2.DOMDocument', @xmlDoc out;

set @sSQL = 'exec dbo.temp';
exec @hResult = sp_OAMethod @cn, 'Execute', @rs out, @sSQL;

while 1 = 1 begin
	exec @hResult = sp_OAMethod @rs, 'Save', null, @xmlDoc, 1;

	insert into @t (xml_data)
	exec @hResult = sp_OAMethod @xmlDoc, 'xml';

	exec @hResult = sp_OAMethod @rs, 'NextRecordset', @rs out;
	
	exec @hResult = sp_OAGetProperty @rs, 'State', @rsState out; 
	if @rsState = 0 break;
end

exec @hResult = sp_OADestroy @xmlDoc;
exec @hResult = sp_OADestroy @rs;
exec @hResult = sp_OADestroy @cn;

select * from @t;