• I agree with Hugo. Unless someone (preferably the author of the QOD) can show how rows can be counted using sp_describe_cursor_columns, the correct answer should be sp_cursor_list, sp_describe_cursor and @@cursor_rows.

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com