Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1009
  • 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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

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