• What is the criteria of the progress? Does this procedure works with a cursor and the loops like While ....?

    If yes, you can determine a number of loops to be completed and have a counter inside a loop that will update second row of a global temp table of 2 rows that is created inside the stored procedure with a name reflecting a user name for example or containing application-generated unique ID. That may resolve the multipel app instances issue. Then the same instance of the application connects to this temp table and gets the overall number of rows from the first row and a current counter from the second row. This will let it to update the status bar

    Do not forget to drop this table at the end of the stored procedure

    Yelena

    Regards,Yelena Varsha