Do triggers trigger other triggers? 1

[Luzian]

If in a trigger I've updated a table that has an update trigger, will it be triggered? Or if in an Update trigger, it updated the same table, would it be some recursive infinate loop?

 

[mrdenny]

If a trigger updates it's parent table then no it shouldn't be refirred. However if a trigger updates another table that has a trigger then the second tables trigger will be fired.

This can be controlled at the server level via the nested triggers option of sp_configure.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com