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

We have 30,000 txs or greater to post.

Here some of the code in short

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

The reason we do this is becasue with a trna on the outside it uses all resources on the clients machine. we can only get about 1200 records updated to the server. if we do it this way we can get 20000 but we still run out of resources. Doe any one know how to clear the cached space so we can clear the cache each time to get through all txs.

TIA
SHAWN