October 18, 2007 at 2:54 am
Hi Everyone,
I have a problem with an update trigger which executes a stored procedure. The sp inserts or updates a row in the same table (direct recursion). However, checks are inplace within the sp to stop recursion after 1 trigger.
The problem: If I execute the stored procedure from query analyser the statements do exactly whats required. If I apply an update on a row in the table which the trigger is set on it locks the record and consequently rolls it back to its original value after the trigger has fired and the sp does not execute the required statements.
Any thoughts
Patrick M
October 19, 2007 at 4:42 am
Hi
Better not to exec a proc inside a trigger particularly if the proc is again inserting into the table.
"Keep Trying"
October 19, 2007 at 4:52 am
Thanks Chirag, that seems to have sorted it. 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply