ID Number: Q70825
1.10
OS/2
buglist1.10
Summary:
PROBLEM ID: PRSQL9103005
SYMPTOMS
After running "DBCC checkdb" on a recently loaded database, there
are errors stating the table is corrupt and the keys should be in
descending order.
CAUSE
Loading a case sensitive database into an insensitive database or
vice versa will corrupt the indexes in the database.
RESOLUTION
BCP out the data, create the tables on the sensitive database,
and BCP the data into the new database.