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; then click Properties.
3. Click the Connections tab.
4. Under Remote server connections, select Enforce distributed transactions (MTS).

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