>>>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

What do you mean here? AFAIK even native RI doesn't allow blanks in FK fields.