uggh; looks like you are doing something in a trigger(inserting/updating into another server?) that should be done in a service broker, or a schedule job that would do the same step periodically, or maybe via a stored procedure that is prepared to handle errors on the event.

the error in the trigger would have caused the trigger to rollback with the error, i think, so the data that was supposed to be inserted is gone.

some things should not be done in a trigger.