AJ, is there an ORDER BY in your query by any chance?
I ask because when you SELECT TOP (N) rows without an ORDER BY, the execution plan will show only N rows being selected by the table scan.
However, if you add an ORDER BY, then the entire table must be scanned and sorted before the TOP (N) rows can be determined.
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills