I've got the same problem with distributed transaction and monstrous SELECT to linked SQL Server. This transaction (executed few times a day) is stuck occasionally (2 times a week) and...