remote proc trans Option
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 properties of transactions. Sessions begun after setting this option to 1 inherit the configuration setting as their default.
The setting takes effect immediately (without a server stop and restart).
For more information about ACID properties, see Transactions.
For more information about MS DTC, see the Microsoft Distributed Transaction Coordinator documentation.
To enforce distributed transactions for remote procedures