>>
Set carry off
>>
>>Actually, I just found out that we were able to reproduce the problem again with CARRY being explicitly set to off. Any other ideas?
>
>Jon, what is the reason for not specifying all columns in the INSERT? That is the standard way and then you don't have to worry about mystery values getting in.
It is not a standard way - not a requirement. If you don't specify some fields in the INSERT command, they would be populated with default values for the fields.
If it's not broken, fix it until it is.
My Blog