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 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 on ACID properties, see Transactions.

For more information, see your Microsoft Distributed Transaction Coordinator documentation.

To enforce distributed transactions for remote procedures

See Also