I actually turn it off in a stored proc that the trigger on the table calls. Therefore the insert that is getting sent is probably returning the row count, but not for all the transactions that occur in the trigger/stored proc sequence.