Trigger / Transaction problem
-
I have a problem with triggers and transactions I need to create a trigger after insert on a table but I would like to fire that trigger only after committing the transaction not before the and on the transaction, any body can help me with this problem I will be thankful for that regards Mhmoud Rawas ------------ Software Eng.
-
I have a problem with triggers and transactions I need to create a trigger after insert on a table but I would like to fire that trigger only after committing the transaction not before the and on the transaction, any body can help me with this problem I will be thankful for that regards Mhmoud Rawas ------------ Software Eng.
Mhmoud, As far as I know triggers cannot be made to work this way. They fire. Period. I would take you logic in the trigger and make a stored procedure out of it. Then call the new stored procedure after you commit the original transaction. You will not have access to Inserted and Deleted but this is the only way I know to do what you describe Hope this helps Bill