Triggers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Triggers

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
S.Jeyakumar

because the recursive trigger setting is off. Roji. P. Thomas
http://toponewithties.blogspot.com

Thanks Thomas
]]>