<div>
<div class="content wysiwyg-content">
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<br />
<br />
DELETE FROM Reminders WHERE &nbsp;ReminderID = (SELECT TOP 1 ReminderID FROM Reminders r JOIN ReminderTypes t ON r.ReminderTypeID = t.ReminderTypeID WHERE r.JobNo = 2643115 AND t.ShortName = 'UnallocatedPhoto')<br />
<br />
If i run the last part after the equals it returns just a single integer value (like it should) <br />
<br />
Any ideas?
</div>
</div>


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?

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.