What is the error your application is receiving?
What database recovery model is in use?
Vyas, MVP (SQL Server)
What hardware is your SQL Server running on?
"john_sheng" <wayne.edu> wrote in message
we are runing a batch update program, which will insert
batch of user records into sql server 2000. The text file
which contains user records is less than 1M bytes. The
memory is 1G, hard driver is 20G totally, 10G is free. CPU
is Intel P3 1.2G.
the program fail if the records include 5000 records, only
4826 records insert into the ...