Error from dbcc

• msi_99

  SSC Veteran

  Points: 250

  More actions

  May 12, 2003 at 8:39 am

  #159505

  Did anyone saw this error message before on sql 6.5?

  Msg 2574, Level 16, State 1

  Index page number 407635 is empty. Status = 0x20.

  Msg 7902, Level 16, State 1

  Data size mismatch occurred while checking TEXT/IMAGE values.

  I have tried BCP out, DTS, select into. The process just hung while executing any of them.

• May 15, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  May 15, 2003 at 9:13 am

  #457301

  Haven't seen this. Have you tried dropping and rebuilding the index? Dropping and rebuiling a clustered index on the table?

  If it persists, I'd call MS before you experience data loss.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net