Home Forums SQL Server 7,2000 Data Corruption REPAIR_ALLOW_DATA_LOSS not resolving the allocation error RE: REPAIR_ALLOW_DATA_LOSS not resolving the allocation error

  • the results for

    select * from sys.indexes where object_id=1591012749

    name index_id

    [font="Courier New"]PK_EXAMPLEUsers 1 CLUSTERED1

    IX_EXAMPLEUsers_clientid 7 NONCLUSTERED0

    _dta_index_EXAMPLEUsers_9_1591012749__1K 8 NONCLUSTERED0

    _dta_index_EXAMPLEUsers_9_1591012749__2K 14 NONCLUSTERED0

    _dta_index_EXAMPLEUsers_9_1591012749__3K 15 NONCLUSTERED0

    _dta_index_EXAMPLEUsers_9_1591012749__4K 16 NONCLUSTERED0

    _dta_index_EXAMPLEUsers_9_1591012749__5K 18 NONCLUSTERED0

    _dta_index_EXAMPLEUsers_9_1591012749__6K 20 NONCLUSTERED0[/font]

    i don't see index_id 22 which was specified in the dbcc results

    does this mean the table itself needs to be recreated?

    thanks