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
 SQL Server Development (2000)
 Triggers and MS SQL 7. No way???

Author  Topic 

AlexCold
Starting Member

39 Posts

Posted - 2001-08-01 : 09:15:46
Stupid situation!!!
Please glance at the part of the diargam
http://www.new.iname.md/reader/6.png
I need cascade deleting. When I delete tbl_SC_Event.ID all related data MUST be deleted too.
MS SQL 7 has no built-in cascade deleting.
MS SQL 7 doesn't supports AFTER delete clause (only FOR delete).
So as far as I see NO way to make cascade deleting in the MS SQL 7...
Or I'm wrong?

FAQTeam member
http://www.faqteam.org/
   

- Advertisement -