FMTONLY and sp_describe_first_result_set dont work with Stored Procedures that have different select columns depending on the parameters
All our report queries rely on FMTONLY to pull the column names as part of the coding of our legacy system. I have some Stored Procedures that return different columns, depending on the parameters passed. Example: