Purpose

The purpose of this article is to teach you the process of enforcing distributed transaction for remote procedures using Enterprise Manager in Microsoft SQL Server 2000.

To Enforce Distributed Transactions for Remote Procedures

The remote proc trans option is used 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. Remote server connections must be allowed before this value can be set.

Following steps describe you the process of enforcing distributed transactions for remote procedure:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click the registered SQL Server i.e. PC54, then click Properties, then select the Connections tab.

3. Now, select the Enforce distributed transactions (MTS) option.

4. Click OK.