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 |
|
nizmaylo
Constraint Violating Yak Guru
258 Posts |
 Posted - 2001-07-27 : 12:20:43
|
| I had nested triggers allowed (since it's default) and ran into the situation where one of the triggers in the chain was starting an infinite loop causing the nesting level to be exceeded. I re-set SQL Server default using exec sp_configure 'nested triggers', 0.I have two questions:1) How do I find out which trigger was starting the infinite loop?2) What are the consequences of resetting SQL Server defaults?helena |
|
|
|
|
|
nested triggers