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 |
|
cecilius
Starting Member
19 Posts |
 Posted - 2002-09-15 : 07:20:08
|
| Hi, does anybody know, how to increase the amount of nested triggers or SPs to more than 32?thx a lot, ceci***ERROR-CODE***Microsoft OLE DB Provider for SQL Server-Fehler '80004005'Maximale Schachtelungsebene für gespeicherte Prozeduren überschritten (Limit 32). Edited by - cecilius on 09/15/2002 07:26:03Edited by - cecilius on 09/15/2002 07:27:32 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-15 : 09:28:46
|
| You can't, and you don't want to. Nesting any deeper than that would cause serious programming issues. You need to look at your trigger and rewrite it to accommodate what you're trying to do.Can you post the code of your trigger and a description of what you're trying to accomplish? |
 |
|
|
|
|
|
Increase nested trigger