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 |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2008-09-19 : 04:12:33
|
| Hi allAccording to BOL :In Recursive Triggers , If any one of the triggers performs a ROLLBACK TRANSACTION, regardless of the nesting level, no more triggers are executed.I have problem understanding the last part (no more triggers are executed), because ENGLISH isn't my native language, so what does it mean? it means that all triggers in the chain(from first one to the current one) will be rolled backed,yes? Thanks in advance.Nothing is quite impossible! |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-09-19 : 05:27:15
|
| Yup, and nothing further will be run. Also the operation that fired the first trigger will also be rolled back as well.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Recursive Triggers.....