Hi,

I have to do an update statement changing the value in one field for 8,000,000 rows in a table. This always fills-up my transaction log - how can I do this without hitting the transaction log?

Thanks.