The log_enable function allows turning regular
    transaction logging off or on.
    A value of 0 terminates logging of DML statements inside the calling
    transaction.  A value of 1 resumes logging of DML statements. Using
    this function one can create situations where a transaction@s outcome
    would be different from the outcome of doing a roll forward of the
    transaction log.There are rare cases where it is more efficient to log an action in
    the form of a procedure call instead of logging the effects of the procedure on
    a row by row basis.  This is similar in concept to replicating procedure
    calls but applies to roll forward instead.