Connection Broken Error

• Nido786

  Default port

  Points: 1482

  More actions

  July 30, 2007 at 5:31 am

  #174001

  MigrationData is my production database last few days i got the error message when i execute a procedure on this database, although i have installed new service pack 4 for sql server 2000.but issue is same could any one help[ me in this regards

  Error "

  Server: Msg 625, Level 20, State 3, Procedure sp_TransformAccountAverageBalances, Line 27

  Cannot retrieve row from page (1:2108289) by RID because the slotid (1) is not valid.

  Connection Broken   "

   

  Regadrs

  Syed Naveed

   

• jsqldba

  SSChampion

  Points: 11257

  More actions

  July 30, 2007 at 7:06 am

  #723288

  check your query. http://support.microsoft.com/kb/814889

  SYMPTOMS

  <script type=text/javascript>loadTOCNode(1, 'symptoms');</script>

  A DELETE statement that includes a JOIN might fail, and you receive the following error message:

  Error: 625, Severity: 20, State: 3

  Cannot retrieve row from page (4:2268) by RID because the slotid (681803120) is not valid..

  However, a DBCC CHECKDB reports no errors, and the Event Log shows no related hardware errors.

  This problem can occur when all the following conditions are met:

  •	A nested loops operator is included in the query plan.
  •	The inner table of the nested loops operator is a target table of the DELETE statement.
  •	The nested loops operator performs a many-to-many join or a one-to-many join.
  •	The input to the nested loops operator contains duplicate values.
  •	The Table Spool operator is placed above the nested loops operator.
  •	The Bookmark Lookup operator is placed above the Table Spool operator.