Is there any way to increase the maximum number of records returned from within CFB2's RDS Query Viewer? 50 is pretty stifling considering the test queries that I run usually return over 10,000 records.
No, but you can use SQL Editor which has no limit.
Inside a cfquery, right click and do SQL Editor.
As of now RDS query viewer show max 50 rows, there is an enhancement logged for this #3231028.
Do you have a URL? This isn't working for me: https://bugbase.adobe.com/index.cfm?event=bug&id=3231028
It says: "The information requested is not found"