Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jaanazam
Starting Member
5 Posts |
 Posted - 2011-07-27 : 11:14:00
|
| Hiby refering the following thread.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14594i 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 SQL2005Maximum 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 advanceAzam. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-07-27 : 12:05:28
|
| Dupe, please refer: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163558 |
 |
|
|
|
|
|
cascade delete (32 nested levels issue)