BCP is the SQL Server utility that you can use
by：Modern Century 2021-03-22
When you run DBCC CHECKTABLE command to check SQL table consistency, you might receive below errors:
Server: Msg 8951, Level 16, State 1, Line 0
Table Corrupt: Table 'table_name' (ID 1797581442). Missing or invalid key in index 'IDX_2' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 0
Data row (1:97:0) identified by (RID = (1:97:0) ) has index values (Col1 = 1 and Col2 = 1 and Col3 = 12 and Col4 = Sep 30 2000 12:00AM!t~0WeG).
The most probable cause of such error messages to occur is that you have used bulk copy operation that has corrupted index pages of unique no clustered index. It occurs when bulk copy operation or DTS (Data Transformation Services) import package inserts duplicate rows into a table, when any of the following condition exists:
The input file you are using contains duplicate rows
The table to be targeted doesn't contain any clustered index and contains a unique no clustered index that has been created with ignore_dup_key option
You have turned on the Select Into/Bulk Copy option
Apply any of these methods to fix such issues:
You should clean the target table by dropping no clustered index. You can then remove the duplicate rows and recreate the unique no clustered index
If problem persists, you can use commercial .SQL Repair software to repair and restore table contents. Since using DBCC CHECKTABLE command with repair option cannot correct this issue, using SQL Recovery software is the only way lefts.
Stellar Phoenix SQL Recovery is an advanced tool to repair and restore damage SQL databases and its components. It supports safe SQL Repair for SQL Server 2008, 2005 and 2000. It can restore database tables, triggers, stored procedures, views, rules and other database components. It is compatible with Windows Vista, XP, 2003, 2000 and NT.