Hi Dan,
Check
SPT cursor fetching and progress displaying for SPT cursor downloading FAQ #8150
>I'm using a cursor adapter now to set the number of rows to fetch as well as the fetch as needed flag.
>
>When I was working with SQL Pass through I didn't see a way to set either of these for a cursor generated on the fly.
>
>I'm was using the SqlSetProp to set both the Asynch and BatchMode flags but there are no settings for the fetch properties that I could find.
--sb--