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