multiplex77
Programmer
Hi,
I placed many triggers on my database tables, and now when I run my page, I get the error
Maximum stored procedure nesting level exceeded (limit 32).
I know this is caused by some recursive trigger, but I've looked through my triggers and can't seem to pinpoint it. Is there a way to find out which is the trigger that is recursive?
Also, is there a way to print out all my triggers (i.e., some T-SQL statement which lists out all my triggers)?
Thanks very much for the help!
I placed many triggers on my database tables, and now when I run my page, I get the error
Maximum stored procedure nesting level exceeded (limit 32).
I know this is caused by some recursive trigger, but I've looked through my triggers and can't seem to pinpoint it. Is there a way to find out which is the trigger that is recursive?
Also, is there a way to print out all my triggers (i.e., some T-SQL statement which lists out all my triggers)?
Thanks very much for the help!