Row Count Less Than Expected

By default, all queries return up to a maximum of 5,000 rows. If you want to change the maximum number of rows returned, you can specify another RowCount value in a SET statement, or use the TOP predicate in your SELECT statement.

If you specify RowCount=0 in the SET statement, the RowCount limit is disabled. However, the RowCount is not actually unlimited. It can be constrained by other factors such as the time interval, or by using the TOP predicate in your SELECT statement.