Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-16 : 08:09:18
|
| howyue writes "according to MS:Indirect recursion Occurs when a trigger fires and performs an action that causes a trigger on another table to fire. This second trigger causes an update to occur on the original table, which causes the original trigger to fire again.initially i wanted to disable nested trigger, as it causes indirect recursion in some tables. but soon i find out tht there's some other tables in my database require nested trigger ! what can i do ?is it possible to have a nested triggers that avoid indirect recursion?" |
|
|
|
|
|
Nested Triggers With No Indirect Recursion?