There is a table Table1, on it the trigger on removal hangs (for delete) T_Table1
There is a table Table2, the trigger for the removal of T_Table2 also hangs on it In the table Table2 there is a link to the Table1 key, the delete rule is a cascade.

Question: when a record is deleted from Table1, referenced by a record from Table2, which trigger will trigger first? It is empirically established that the second, but is this always the same behavior?

    1 answer 1

    All cascading referential actions, directly caused by the original DELETE or UPDATE statements, are executed first.

    http://msdn.microsoft.com/ru-ru/library/ms186973%28v=sql.105%29.aspx , section "Triggers and Cascading Reference Actions"