Solved

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

Posted on 2007-12-05
1
976 Views
Last Modified: 2008-03-11
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
Comment
Question by:Type25
1 Comment
 
LVL 8

Accepted Solution

by:
i2mental earned 500 total points
ID: 20411207
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question