We have an app that builds transactions and then posts all the txs to the server.

We have 30,000 txs to post.

here is the code in short

do while !EOF()
begin tran
insert into .....
end tran
enddo

about the 12,000 we have a failure error 43 not enough memory.

can anyone help.

TIA
SHAWN