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 |
jmohan1984
Starting Member
2 Posts |
Posted - 2012-12-18 : 07:39:44
|
Hi, Please provide me an example for INDIRECT RECURSIVE TRIGGER.Thanks |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-12-18 : 09:06:39
|
There is an example (i.e., descriptive, not code) on the MSDN page here that describes recursive triggers.If you do want to test it out, be sure to set the RECURSIVE_TRIGGERS (at database level) and NESTED TRIGGERS option (at server level) appropriately (also described on that page). |
|
|
|
|
|