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.

  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.

    ms190773.note(en-US,SQL.90).gifNote:
    Remote server connections must be allowed before this value can be set.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft