Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maximum stored procedure nesting level exceeded

Status
Not open for further replies.

multiplex77

Programmer
Dec 25, 2001
302
SG
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! :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top