FIX: Table Corruption When Using BCP with SELECT INTO/BULK COPY, Nonclustered Index, and IGNORE_DUP_KEY

Article translations Article translations
Article ID: 277547 - View products that this article applies to.
This article was previously published under Q277547
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 57899 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

Table corruption errors may occur on index pages under the following conditions:
  1. The SELECT INTO/BULK COPY option is on.
  2. A bulk copy program (BCP) operation is done with the IGNORE_DUP_KEY option specified.
  3. The target table has a nonclustered index.
The underlying data pages are in a consistent state; however, the following errors can be seen when you run DBCC Checkdb:
Server: Msg 8951, Level 16, State 1, Line 1
Table Corrupt: Table 'table_name' (ID 1941581955). Missing or invalid key in index 'index_name' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:365:0) identified by (RID = (1:365:0) ) has index values (store_number = 1211 and ssn = '440921916' and date_worked = Feb 7 2000 12:00AM?|??WeG and clock_in_time = '16:53' and clock_out_time = '19:08').
NOTE: The issue does not occur if there is a clustered index on the table in question.

RESOLUTION

To work around this problem, rebuild the affected index by using one of the following methods:
  • Drop and then re-create the index.
  • Use the DBCC DBREINDEX statement.
  • Use the REPAIR_FAST option with DBCC CHECKTABLE. (In some cases, it may be necessary to run this command more than once.)

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.

Properties

Article ID: 277547 - Last Review: October 21, 2013 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB277547

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com