>Can someone give me a clear answer. When is it more appropriate to use
>Begin Transaction .... End Transaction vs Bufferring .. TableUpdate


Transactions and buffering are different animals. I always use transactions, buffering, and tableupdate. There is no way to ensure that multiple tables are updated without transactions. This has nothing to do with buffering and tableupdate.