• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1015
  • Last Modified:

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

Why when i run this statement do i get the error: Cannot retrieve row from page (1:65580) by RID because the slotid (2) is not valid

DELETE FROM Reminders WHERE  ReminderID = (SELECT TOP 1 ReminderID FROM Reminders r JOIN ReminderTypes t ON r.ReminderTypeID = t.ReminderTypeID WHERE r.JobNo = 2643115 AND t.ShortName = 'UnallocatedPhoto')

If i run the last part after the equals it returns just a single integer value (like it should)

Any ideas?
0
Type25
Asked:
Type25
1 Solution
 
i2mentalCommented:
There is a fix from microsoft for this as well as a workaround listed in their knowledgebase.

http://support.microsoft.com/kb/814889/en-us
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now