Microsoft KB Archive/70825

PRSQL9103005: Cannot Load Case Sensitive DB Into Insensitive 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.