Break up the insert into smaller numbers of rows, and run them sequentially.
How you go about doing that depends on your import method.
If what you're doing is a single bulk import, then maybe the database needs to be put in "Bulk Logged" recovery model, to minimize the impact on the log, and then you don't have to break up the import.
Can you provide some details on what you're currently doing? If so, we can provide more specific advice.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon