Triggers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


Hi all,
I have created the insert trigger for Table A.
Inside the Trigger , i am inserting into the same table.
Its allowing to compile the trigger.If i try to insert the table, the trigger code
is executing once.
can u pls clarify , why should it running once? Thank You Regards

because the recursive trigger setting is off. Roji. P. Thomas

Thanks Thomas