I agree with you on that , cause other wise there could be a big hit on a log file every time a long running transaction get's committed. the reason I asked was that I couldn't find the accurate explanation on the web. Thanks