Export (0) Print
Expand All
Expand Minimize

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

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Connections node.

  3. Under Remote server connections, select the Require Distributed Transactions for server to server communication check box.

    NoteNote

    Remote server connections must be allowed before this value can be set.

Community Additions

ADD
Show:
© 2014 Microsoft