Steve

Sorry - would have quoted but the forum was insistent on quoting another post when I clicked quote 😀

I would put money on the fact that when you used SET ROWCOUNT one of the two following possibilities was true:

1) There was no where clause on the statement

2) The where clause was easily satisfied by an index

...