Export (0) Print
Expand All

remote proc trans Option

SQL Server 2000

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

Enterprise Manager

Transact-SQL

SQL-DMO

See Also

RECONFIGURE

Setting Configuration Options

sp_configure

Show:
© 2015 Microsoft