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

What is native RI? You ignore it or set it. What does it matter if FK is null or empty when you're ignoring it. The only thing that matters is managing the nulls complexity.
Cetin