November 12, 2002 at 8:17 am
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.
November 12, 2002 at 8:21 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply