Management Studio doesn't go through ODBC and VFP translation layers.
>I have install SQLExpress2008 on a WS2003 with 2 Gb RAM (development machine)
>
>When I run a query against a table with 100.000 records from the Microsoft SQl Server Managent studio:
> [ Select top 1000 from sometable ]
>It returns the results in less than a second.
>
>But when I run the same query from VFP
> [ sqlexec(nHandle, "Select top 1000 from sometable ", "cur") ]
>It takes for ever, more than 15 seconds.
>What is the problem ?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer