InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:04:35 GMT20http://www.sqlservercentral.com/Forums/Topic1419764-391-1.aspxuggh; 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.Thu, 14 Feb 2013 06:30:50 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1419764-391-1.aspxThat's not much to go on. Do you have any details of it? DDL? Insert statement?Thu, 14 Feb 2013 05:46:13 GMTEd Wagnerhttp://www.sqlservercentral.com/Forums/Topic1419764-391-1.aspxI have trigger on a table and it failed when i insert on a table with below errro message and its SQL Server 2005 version.Msg 8525, Level 16, State 1, Line 1Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.ThanksWed, 13 Feb 2013 15:54:24 GMTAdmingod