>Hi ,
>
>I have application in Visual Foxpro 7.0 using backend SQL-SERVER.
>
>We have a stored procedure which takes 20-30 minute to process.
>I want to show a progress bar or somthing which notify to my application about percentage done.
>
>Can I do this?
>
>Ajay Mishra

Not with a stored procedure unless you break up the code into several procedures. There may be a hack using SPT commands but it would probably slow it down even more. The other option is to set the cursor to an hourglass so the user knows something is working.