I have trigger on the update of a table which calls a stored procedure to update another table on a linked server.

If the trigger is called from Query Analyzer, it works fine and both the tables are updated. But when the trigger is called from an appplication (in this case, a Delphi app), the whole transaction fails. Even the origianal table is NOT updated.

Any help is appreciated.

Thanks,
-HP

Me again. I found the solution. The following need to be set before doing any inserts or updates through an implicit or an explicit transaction. I put them in the trigger before calling the stored procedure.

<start trigger>

SET XACT_ABORT ON
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON

<call the stored procedure>
<end trigger>


I hope this helps somebody else too.

-Hari

Apply SP 3a...
Shawn Shi