Extent Chain for object not correctly linked

  • Hi,

    We've got this error when copying data from a temporaray database to a live one.

    "[Microsoft][ODBC SQL Server Driver][SQL Server]Extent chain for object 844530042 is not correctly"

    SQL 6.5

    Any suggestion/s are greatly appreciated.

    Thanks,

    Tien.

  • Try doing dbcc checktable or dbcc reindex on 844530042 object_id......

    Well I don't know what is the equilent commands in sql6.5....

    Now copy it I think it should work.......

    Cheers,

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply