>Trey, Macer
>
>Thanks from both of you. I'll give it a try. Looks fairly straight foward.
>
>Kevin

One other quick note. Foreign key constraints are checked prior to any trigger firng in SQL Server. This could present a problem if you want to handle RI using triggers. The constraint will prevent the deletion in the parent table from occurring (if records exist in the child) and therefore neither the initial deletion nor the cascade deletion will take place.

FWIW, I heard at NOLA that SQL Server 2000 will have cascade deletes and updates.