Posted - 07/27/2011 : 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