>>I've got a stored procedure that I'm trying to execute from a VFP program. If I execute the stored procedure from Query Analyzer takes less than 1 second. However, the same call performed as a SQL passthru from within a VFP application could take anywhere between 14~40 seconds. What would account for the delay?
>
>Run SQL Profiler and check what VFP sends to SQL Server.
Thanks -- noticed the call isn't quite the same (goes thourgh a system stored procedure).