>>Set null off
>>
>>PS: Nulls are evils. Don't use them if unless you really know what you're doing. Generally they are over used when one really doesn't need them.
>>Cetin
>
>Here is the rule we're using in our system: ALL FK fields can be either value or NULL, they should never be empty. All non-FK fields should be either empty or value. Our RI allow to have NULLs in FK.
>
>Anyway, looks like I need to switch back to SET NULL OFF and just explicitly set all FK fields for Trans to be null if they are not in Stage_trans.

Change your rules.
Cetin