> When I look in SYS_DEFAULT table I find the trouble-making COLUMN_ID
> three times with different SYS_NEXT values.
> Question1: Can I delete two of the three entries without causing further
> trouble?
We had a similar problem once. Our Autonumber column somehow "forgot" the
next number. When I tried to reapply the autonumber I got a duplicate entry.
I'll be honest in that I don't remember the version. However, I believe that
someone on this list told me the trick. Simply run "autonum delete" for each
instance of the corruption.
Jenna