Ajay,
If you use an asynchronous connection, you can use a call to SQLExec() and then call SQLMoreResults() from a timer to find out when the SP has actually finished. You don't really know % complete though, you can however at least display elapsed time so they can know based on history how long the SP has been taking to run.
>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.