Hi Kevin

>1) If I'm running a long query from VFP using SQLEXEC() to run a query in SQL Server 2000, is there any way I can show a progress bar to show the user how far along the query is?

I don't think so. You could set up an Asynchronous connection and then use a progress bar in the VFP end but I don't see how you could determine how far SQL Server has got through the query. The best thing would be to use something like a little clock ticking to show that the thing is still 'alive' rather than trying to predict how long it will take.

Of course you could also adopt the microsoft approach and say "10 seconds remaining" for the first 3 minutes, then "5 seconds remaining" for the next three and so on < g >

>2) Related question...if a query run using SQLEXEC() takes more than a few seconds, I get a 'Executing remote... to cancel...' Is there any way to suppress that statement?

Doesn't "SET NOTIFY OFF" prevent that one?

----
Regards
Andy Kramek