Cascade deletes in SQL Server 7.0?

Is it possible to have data deleted(automaticly) from tables related to the one im deleting from..

Example:

Table A have a one to many relation to 6 other tables.

I will delete a member from Table A, will the data conserning the member in the other 6 tables be automaticly removed?

Best wishes.

(If not, how should I write the sp to handle this task?)For SQL Server 7.0 you would have to implement TRIGGERS to perform cascade deletes. However in SQL Server 2000 there is cascade deletes, defined by 'Cascading Referential Integrity Constraints'|||Okay!

Thanks for responding - Scre@.m