Excellent article about Long Running Transactions by Charles young.
Charles young has written another great article. Most of his articles are worth a read. This article covers long running transactions and how to handle them.
Follow this link to read the article