Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Continuous warning in eventviewer for WCF-SQL adapter › Re: Continuous warning in eventviewer for WCF-SQL adapter
January 10, 2014 at 9:29 AM
#26242
If you trace sql profiler to trace the commands, you should see your polling statement being triggered,
and because empty was return, it give you this warning message.
My setting is different, i have ambienttransaction = false, pollwhiledatafound = false
the differences is, in my stored procedure I have this to making it "xml"
if [datarow count] > 0
begin
–xml generating statements
end
else
begin
select ' ' for xml path('')
end