We have a service which uses LINGTOSQL to process some updates on a remote SQL box. On some machines everything is fine and it works without DTC enabled. On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn't been enabled correctly. This is on SQL 2008 and SQL 2008 R2 environments, on Server 2003. Are there any suggestions of why we might see this behavior in only some environments?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!