Error - Msg 605, Level 2 ... Attempt to fetch logical page ...
Posted on 2008-10-16
I was running a simple query on a large table tab1 with a where clause depending on two smaller tables (tab2 and tab3) where the nested query only returns 633 values.
select * from tab1 where id in (select id from tab2 inner join tab3 where ...)
and get the following message
Msg 605, Level 21, State 3, Line 1
Attempt to fetch logical page (7:5707686) in database 6 failed. It belongs to allocation unit 0 not to 359756898631680.
Any idea what's going on?