Linked server transaction error
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.