>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
Thanks, I'll try that. It just happens that my I'm doing daily updates (starting at Jan 1, 1998) which are approx 6,000 rows per day. On Mar 30, 1998 the update hit 57,000 and at about 20,000 slowed to a crawl. I was just about to post another question so I'll hang ten on that and try your suggestion.