>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer