I am running a batch procedure on a table that has over 700,000 records.
It's going through each of those records and doing a search on the key to
another table and updating some values based on that search. However, the
batch seems to be stopping each time at just under 25,000 records. The
transaction log is not full... any ideas why this is stopping? This
procedure is going to take days to run and this setback is annoying.
Thanks in advance for any and all help