>Is there any other ways?

Not that I know of. If it must be within a single transaction, the transaction log will have to hold all the necessary info to rollback the transaction if required. I think you're stuck with a really big log.

-Mike