>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.

Thanks. That looks like what I need.

When I was reading the DOCs it looked like you would need a cursor before setting these properties.

Dan