I find this on this link:
http://forums.databasejournal.com/archive/index.php/t-12203.html
Problem:
With autocommit OFF, distributed queries with joins or subselects
between tables on a development server and a linked production server
produce the following error:
Server: Msg 3910, Level...