Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32) Expand / Collapse
Author
Message
Posted Monday, October 15, 2007 3:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 23, 2007 7:53 AM
Points: 4, Visits: 10
im new to sql. i have created a delete trigger in table1. once i deleted the record in table1 it will also delete that specific record in Table2. And in table2 also, i had created a delete trigger. Once the record of table2 will deleted, that specific record will be deleted in table1. But everytime i delete i delete a record there is an error message will appear. And its "Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32)". What does it mean? Can you help me with this? Any one. How can i create a delete trigger in two tables without having an error like this?
Post #411033
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse