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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 performing a cascade delete

Author  Topic 

Quadracerke
Starting Member

4 Posts

Posted - 2003-08-27 : 06:41:48
Hi,

I've just tried out the script to perform a cascade delete( www.sqlteam.com/item.asp?ItemID=8595 ) but when I try it I always get this error Server: Msg 217, Level 16, State 1, Procedure spDeleteRows, Line 58
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

Does anyone know what the problem can be?

thanks in advance,

Dries

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-08-27 : 07:35:44
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28734
Go to Top of Page
   

- Advertisement -