Michael,

I have posted this over in the VFP area and someone suggested that I try table level buffering instead of row buffering (which actually made the problem worse).

The trigger calls a stored procedure which processes the inserted record(s), updating another table (a summary history table) with values from the inserted record(s).

It seems very odd that the remote view in Fox would have all 1000 records ok, but that the SQL table would be missing records. If the trigger is failing on the back end, wouldn't it cause an update error to be returned to Fox?

Thanks for any help/insight you might have.