Direct referential integrity with cascade delete or update is a new feature in SQL2000. You must use triggers to accomplish the cascade action in SQL2000. Create a delete trigger which deletes the child records on the delete.
Below is a script for an example trigger from my production system.


CREATE TRIGGER T_tbl_PolData_DTrig ON dbo.tbl_PolData FOR DELETE AS

SET NOCOUNT ON

/*** note PRIMARY CASCADE DELETES occur through referential integerity (DRI)

this trigger only cascade deletes to tables without DRI

As of 5/6/02 only tbl_ReportData**/



/* * CASCADE DELETES TO 'tbl_ReportData' */

DELETE tbl_ReportData FROM deleted, tbl_ReportData WHERE deleted.Pol_ID = tbl_ReportData.Pol_ID



Brian Freeman
Bluwave Computing/Carnegie Technologies
www.bluewave-computing.com / www.carnegie.com
(770) 916-0595 ext. 415


-----Original Message-----
From: Khaled Harb [mailto:[Email Address Removed] Wednesday, June 25, 2003 3:53 AM
To: LazyDBA.com Discussion
Subject: How to implement Delete Cascade on table in SQL Server 7


DBA's

How I can to implement Delete Cascade when deleting record on table in
SQL Server 7 database

Thanks



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page