I ran into this problem awhile back with a fairly complex database.  SQL Server's cascade delete could not handle self-referencing columns, such as a ManagerId Column in an Employee table...