• Had to refer to BOL to check out those sp's, since I don't use cursors (a Best practice as Hugo pointed out).

    However, as the other commenters above already pointed out, I see no way to get or construct the number of rows in the cursor from the info sp_describe_cursor_columns returns, as all this info is about the columns in the cursor (as one probably might expext from a sp with that name :)).

    So QotD-poster: please show us the code that uses sp_describe_cursor_columns to count the original cursor's rows.

    Peter Rijs
    BI Consultant, The Netherlands