I'm calling a stored procedure (SP) from within a VFP 6.0 app using Sql Pass-through (SPT). The SP initially processed a long list of tables within the SP itself within a FETCH statment. I needed some sort of progress bar in my UI, so I modified the SP to receive a parameter specifying the table and moved the call to the SP to a loop inside my form code. This gives me some form of monitoring that I can display to the user as I move from table to table. However, it got me wondering if I'm missing something in SQL that I could hook into to get a process status from within the SP.

Working with the original code model, does anybody have any creative way to display processing status within a SP? Is there a way to get this progress via SPT to display in the UI?

Thanks for the help in advance.