Automatic cascade deletes are NOT automatic in 7.0... you need to use triggers, that is correct. However, automatic cascade deletes are in SQL 2000.

BOb


>I am being told by my local DBA that automatic cascading deletes are possible in MSSQL7, that you must write nested triggers to conduct cascade deletions.
>
>Example:
>
>article, exam and result tables.
>
>- The article_id is the primary key of table article, and the foreign key of the table exam.
>- The exam_id is the primary key of table exam and the foreign key of the table result.
>
>I want to remove
>- 1 record, article_id = 5 in table: Article, and
>- 2 records with the same article_id = 5 and their exam id = 1 and 2, in the Exam table, and
>- 7 records with the Exam_id are 1 or 2 in the Result table.
>
>?