Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 cascade delete (32 nested levels issue)

Author  Topic 

Starting Member

5 Posts

Posted - 2011-07-27 : 11:14:00

by refering the following thread.

i need to delete the records in child tables which references the id of the parent table.
i used the above sp : "spCascadeDeleteLong".
it runs good but giving the following error due to nested levels exceeding 32 could you please paste the new version of code which solves the problem of nested levels as iam using the SQL2005

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

its very urgent i need to solve this issue.
expecting the quick response from you.

thanks in advance


Most Valuable Yak

15732 Posts

Posted - 2011-07-27 : 12:05:28
Dupe, please refer:
Go to Top of Page

- Advertisement -