Retrieve error on temporary table

• celestialone

  SSC Rookie

  Points: 37

  More actions

  November 12, 2002 at 8:17 am

  #159194

  I am running a stored procedure. I insert records into a temporary table and then manipulate them. When attempting to do a delete on this temp table, I get an error "Server: msg 625, Level 20, State 3, Procedure sp_case_counts, Line 494. Cannot retrieve row from page (35:77:77) by RID because the slotid (949139376) is not valid. Connection Broken". It appears to be data related because I'm able to successfully delete previous rows from the temporary table, but if I remove the 'offending' record from the initial selection criteria it happens on a different record. According to on-line help, this is a database corruption problem, but since this is a temporary table I'm not sure how to troubleshoot it. I'm baffled.

• paulhumphris

  Hall of Fame

  Points: 3496

  More actions

  November 12, 2002 at 8:21 am

  #441123

  I can't say that I fully understand the specifics of the errors you are receiving but as a work around have you tried using a table variable.

  In many cases table variable can give better performance that temporary tables since they exist in memory and not on disk.