Hi @Ransford Graham ,
If the stored procedure works well in SSMS, then there is no issue with SQL server procedure. This issue may related to some limits that calling SQL procedure in FoxPro SQL Pass Through. Suggest you post your issue on FoxPro Forum for better help.
In addition, the error message that you offered is too less for analysis. Please share more related error message from SQL server error log and application log to get better help.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".