>Actually I thought I got it but I am still having the problem. I narrowed it down that it only happens when I try seeking on this specific table. this table seems to be the same as all the other ones. DO you have any other ideas?
Maybe table indexes got corupted? Try to delete all indexes on that table and recreate them from scratch.
--sb--