i noticed theres a problem wit my transaction statements in my stored procedure, so i may hav a reentrant problem. id try to fix dat and then try my run...

i noticed my active transactions log =1

is this normal

finally got my counters, the Target server memory is 622416mb and the Total Server Memory is 45920mb, after about 1hr.

Target server memory =621568

Total server memory=45808

i really dnt think its a memory...

tanks once again for ur response...i'm currently running my scripts again...(i dint add the counters for Memory Manager)i'l nid to check them after an hour cos dats when the problem...

Hello, tanks for ur prompt response u guys...

i have about 40Gb HD space so i dont think dat shld b a problem...

i use stored procedures to do the inserts...

this is...