Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Getting process status within a stored procedure
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement