Specified Reasons are quite enough to understand that why below method is more accurate.

But actually author made a mistake here.

I mean that Method is right but query written is logically...

sp_cursor_list, sp_describe_cursor and @@cursor_rows.

are correct answers. as already so many comments are there so no explaination required for the same.

and one more thing If it is said "@@cursor_rows" requires Non-Dynamic...

I think FMTONLY Executes query. as i came to know from earlier comments, FMTONLY returns meta data without processing any row how can it estimate the query response. please clear...