How to enforce distributed transactions for remote procedures (Enterprise Manager)

To enforce distributed transactions for remote procedures

1. Expand a server group.
   
   
2. Right-click a server, and then click Properties.
   
   
3. Click the Connections tab.
   
   
4. Under Remote server connections, select the Enforce distributed transactions (MTS) check box.

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