>Nigel ---
>
>VFP? I thought this was a SQL Server issue?
>

It's a client/server issue. I have two and a half million rows to insert into SQL Server and want to find the fastest process.

I think I have found it! Use a remote view pointing to an un-indexed, empty table, APPEND FROM my source data then fire a remote stored procedure to insert to the main table and drop/delete the middle table. Solves all the problems I have been encountering over the past few weeks and is twice as fast as my previous solution (which snailed on larger inserts). It's not my first choice - I would rather insert into than append from but it works!