Database consistency (Server: Msg 8951, Level 16, State 1, Line 1 )

• sntiwary

  Hall of Fame

  Points: 3475

  More actions

  April 10, 2005 at 6:11 am

  #166572

  Hi,

  I am getting database consistency error for one of my database:

  Server: Msg 8951, Level 16, State 1, Line 1

  Table error: Table '<TABLENAME>' (ID <OBJECTID&gt. Missing or invalid key in index '<INDEXNAME>' (ID <INDEXID&gt for the row:

  Server: Msg 8955, Level 16, State 1, Line 1 Data row (1:133:42) identified by (RID = (1:133:42) ) has index values (<INDEXNAME> = 0).

  I tried DBCC DBREIDEX , DBCC checkdb with repair options (repair fast and repair rebuild). It did not slove the problem.

  Pls let me know if  any one has encountered this issue before and fixed it, It will be a great help to me.

  Thanks in advance

  -snt

• philcart

  SSC-Forever

  Points: 47795

  More actions

  April 10, 2005 at 7:08 am

  #551755

  What service pack are you running?

  Try dropping and re-creating the index for starters.

   

  --------------------
  Colt 45 - the original point and click interface