Quote:
Is there some sort of direct access utility in MSSQL?


If you right-click on a table in SQL Management Studio, you can choose the "Show Table" item, which displays the rows.

I suspect that you've got a corrupted index (which shouldn't happen). I suspect this because a table scan works, but a query (using the index) doesn't. Drop the index and recreate it.
_________________________
-- roger