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

>>I also tested this same query in VS.Net 2.0 from the Server tool and got a similar result as with VFP. I copied the query from the VS.Net query panel to the QA and it ran in less than a blink of the eye.
>>
>
>What are you using to connect SQL Server from VFP, SQL ODBC, Native client?
>My guess is that one of setting is different when query is run through QA or otherwise.