Extent Chain for object not correctly linked

• tienvo

  SSC Enthusiast

  Points: 112

  More actions

  August 22, 2002 at 9:19 pm

  #79367

  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.

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  August 23, 2002 at 12:46 am

  #435156

  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