How to: Enforce Distributed Transactions for Remote Procedures (SQL Server Management Studio)
Use the remote proc trans option to protect the actions of a server-to-server procedure through a Microsoft Distributed Transaction Coordinator (MS DTC) transaction. Set remote proc trans to 1 to provide an MS DTC-coordinated distributed transaction that protects the ACID (atomic, consistent, isolated, and durable) properties of transactions. Sessions begun after setting this option to 1 inherit the configuration setting as their default.
To enforce distributed transactions for remote procedures
In Object Explorer, right-click a server and select Properties.
Click the Connections node.
Under Remote server connections, select the Require Distributed Transactions for server to server communication check box.
Note
Remote server connections must be allowed before this value can be set.