>I have tried loading data for first time on SQL server 6.5.
>The NT4 server was PII 350mhz with 64 mb ram as domain server and sql server. The terminal or client was a AMD k6 450 mhz with 128 mb ram with win 98.
>
>I tried load 38000 records from a vfp table to remote view of sql server. It took about 35 mins to complete the task.
It doesn't appear you are doing anything wrong. What is the size of each record? IOW, how much data is being pumped into SQL Server? Also, what is the connectivity between the two machines? Fast (100 Mbit) ethernet? 10 Mbit?
One other thing. If it's possible, I suggest you switch the memory from your 98 machine to your NT machine. If not then go out and upgrade the memory. 64 MB of RAM isn't that much when dealing with NT and SQL Server. You will be hitting the page file alot.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao