>If you can get some info on the drivers I would be most grateful. I am also doing this work at home and get home before 5.30pm - if you could email me at my private address - nigel@coates.freeserve.co.uk - I could then try it this evening.
>Many thanks.
>
>>Another thought.
>>
>>It could be you client configuration. I haven't got SQL Server on my machine here right now, I can mail you exact details when I get home.
>>
>>If I remember rightly, there is a client configuartion utility that appears on the SQL Server menu options (from the win95/nt start button).
>>
>>In here you can set the communications driver to be used between the client and the server. You may be using the general driver, which may try a number of different protocols.
>>
>>Using the utility, try selecting the IP or TCP/IP specific drivers.
>>
>>

Nigel,
I have the same situation, where I have to update SQL tables from VFP. At this point, it still takes several hours, but I'm updating quite a bit more data. One thing I did to increase the speed was to drop the clustered index before the update, and then re-create it after. This speeds up the process quite a bit, and the re-create doesn't take long at all.
Brad