I receive an error when trying to enable the new trigger that I am currently working on. The error says "Can not enable trigger due to 2 cascading triggers".
I don't see anything wrong with my trigger, I'm just passing the records to another table from #inserted.
Can someone help?
This error occurs when you exceed the limit of 2 cascading triggers. Caspio's cascading triggers is only limited to 2.
Now, what are cascading triggers?
This is when, a triggers action activates another trigger.
So for example,
Table A has trigger 1 > The trigger is to Update Table B.
Table B has trigger 2 > Trigger 2 runs on UPDATE, then again activates another trigger.
Now these are cascading triggers. These acts as a waterfall trigg