Microsoft KB Archive/70825: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q70825 to Microsoft KB Archive/70825 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
| |
Latest revision as of 19:29, 12 August 2020
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.
