That gets a little more interesting..
Are you using the same connection type in query analyzer and VFP (SQL authentication vs Windows authentication)?
Is the VFP time including time to connect? If so, how long does it take AFTER you have a connection handle?
>For this query only 21 records are being returned. Ant I can execute this query both remotely and on the server with the same results. I ran the sql profiler and the query appeared to be the exact same as the analyzer.
>
>Glenn
>
>>How many records are being returned?
>>
>>If there are lots of records in the result set then it could simply be a network throughput issue assuming you are running query analyzer on the server (no network issue there)..
>>
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________