The query which I am running on the server is:

ls = SQLSTRINGCONNECT("driver={SQL Server};server=(local);database=AWS2;uid=aspnet;pwd=;Trusted_Connection=Yes;size=8192")
lnstart = SECONDS()
? SQLEXEC(ls,[Select squeezedesc From inv Where SqueezeDesc like 'thehook%'])
? SECONDS() - lnStart
= SQLDISCONNECT(0)

The connection used by QA is windows authentication.

Glenn


>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)..
>>>