>
>What are other factors in this equation? Is it direct Insert or a view/CA? Any timers?
>>
>>Can you create a simple repro?>
>It's a direct insert to the table in question. There are global timers running in the application, but the insert is not related to a timed event. Unfortunately, I can't create a simple repro at the moment because we cannot get the wrong behavior to reproduce every single time.
Joh,
Very hard to suggest anything, since it's definitely not normal behavior. Perhaps as suggested by Tore just to prevent bad data (not really a good solution, since we don't know the cause) is to specify all fields in Insert with their default values.
If it's not broken, fix it until it is.
My Blog