Open Question

SQL Server Table Corrupted after Inserting Duplicate Rows ?

After having inserted the duplicate rows, I tried to access the table but instead of viewing the data, I was denied access to it. So I ran the DBCC CHECKTABLE command and it gave me the following error message:

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 aforesaid message was All Greek to Me as I could not understand a single thing of it. Can anybody explain to me the reason behind this cause and the way to fix this problem? Any help would be greatly admired.

516 day ago

Answer this Question

    Comment(s) (0)

    Report Abuse