Advertisement
- Home
- Microsoft
- Development
- MS SQL Server
- SQL Server 2005
- Cascade delete problem
Advertisement
- 1. chapmandew 2,035,326
- 2. angelIII 1,369,238
- 3. aneeshatti... 513,981
- 4. mark_wills 473,116
- 5. ee_rlee 313,995
- 6. brejk 226,005
- 7. dtodd 209,505
- 8. momi_sa... 177,049
- 9. acperkins 173,863
- 10. rickchild 167,940
- 11. ptjcb 160,219
- 12. Thomasian 155,142
- 13. EugeneZ 143,750
- 14. BrandonG... 143,655
- 15. sbagireddi 136,982
- 16. dportas 125,215
- 17. ScottPletc... 123,615
- 18. jgv 115,921
- 19. appari 114,604
- 20. PFrog 113,160
- 21. DanielWilson 106,114
- 22. chrismc 105,889
- 23. PedroCGD 104,345
- 24. tedbilly 103,765
- 25. bashka_... 98,724
- 1. angelIII 2,649,429
- 2. chapmandew 2,035,326
- 3. aneeshatti... 1,079,086
- 4. ptjcb 525,611
- 5. Yveau 517,373
- 6. mark_wills 473,116
- 7. dtodd 420,510
- 8. PFrog 383,188
- 9. dqmq 368,078
- 10. appari 350,751
- 11. imitchie 333,350
- 12. ee_rlee 313,995
- 13. acperkins 269,202
- 14. ScottPletc... 227,282
- 15. brejk 226,005
- 16. Lowfatsp... 223,289
- 17. matthews... 203,352
- 18. rboyd56 196,590
- 19. SQL_SE... 190,215
- 20. EugeneZ 180,459
- 21. momi_sa... 178,749
- 22. gbshahaq 177,810
- 23. tedbilly 172,104
- 24. DanielWilson 171,904
- 25. dportas 169,180
| 05.04.2008 at 03:12PM PDT, ID: 23375319 |
|
[x]
Attachment Details
|
||
Cascade delete problem
Asked by Cragly in SQL Server 2005, Programming for ASP.NET
Tags: Microsoft, SQL Server 2005
Hi all,
I am attempting to create a simple internal messaging system and have come up with the following schema. My problem is how to handle the cascading deletes that take place within the system. An example of this would be when a user is deleted and I would want to then delete everything associated with that user. Am I best adding cascade updates and deletes to some relationships and then triggers for the others? Therefore adding a cascade delete to the aspnet_Users MsgFolders and then on the MsgMessages folder add a Delete trigger to then delete the related MsgRecipient record? Maybe my schema design is not quite correct?
Any help on this would be much appreciated.
Thanks
Cragly
Start Free Trial
I am attempting to create a simple internal messaging system and have come up with the following schema. My problem is how to handle the cascading deletes that take place within the system. An example of this would be when a user is deleted and I would want to then delete everything associated with that user. Am I best adding cascade updates and deletes to some relationships and then triggers for the others? Therefore adding a cascade delete to the aspnet_Users MsgFolders and then on the MsgMessages folder add a Delete trigger to then delete the related MsgRecipient record? Maybe my schema design is not quite correct?
Any help on this would be much appreciated.
Thanks
Cragly
Start Free Trial
Attachments:
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628
