Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2000
Microsoft SQL Server 2000
How To
SQL Server Enterprise Manager
Administering SQL Server
Managing Servers
How to register a server (Enterprise Manager)
How to create server groups (Enterprise Manager)
How to change a server's registration (Enterprise Manager)
How to remove a registered server running SQL Server (Enterprise Manager)
How to connect to a registered server running SQL Server (Enterprise Manager)
How to disconnect from a registered server running SQL Server (Enterprise Manager)
How to assign the sa password on a newly installed server (Enterprise Manager)
How to view server properties (Enterprise Manager)
How to check and set remote server configuration options (Enterprise Manager)
How to set access to your display of servers and groups (Enterprise Manager)
How to set the polling interval (Enterprise Manager)
How to disable a remote server setup (Enterprise Manager)
How to manage or view SQL Server messages (Enterprise Manager)
How to edit a SQL Server message (Enterprise Manager)
How to delete a SQL Server message (Enterprise Manager)
How to add a new SQL Server message (Enterprise Manager)
How to find a SQL Server message (Enterprise Manager)
How to set up a linked server (Enterprise Manager)
How to delete a linked server (Enterprise Manager)
How to configure log shipping (Enterprise Manager)
How to remove log shipping (Enterprise Manager)
How to add or edit a destination server (Enterprise Manager)
How to delete a destination server (Enterprise Manager)
How to view the status of servers configured for log shipping (Enterprise Manager)
How to view or edit information about the source server (Enterprise Manager)
How to view or edit information about the destination server (Enterprise Manager)
How to add an external tool to the Tools menu (Enterprise Manager)
How to launch SQL Server Enterprise Manager in the Computer Management console (Windows)
How to enable child windows (Enterprise Manager)
How to configure the affinity mask (Enterprise Manager)
How to set the allow updates option (Enterprise Manager)
How to configure the cost threshold for parallelism (Enterprise Manager)
How to set the default language (Enterprise Manager)
How to set a fixed fill factor (Enterprise Manager)
How to configure the number of processors available for parallel queries (Enterprise Manager)
How to set minimum query memory (Enterprise Manager)
How to configure the maximum number of worker threads (Enterprise Manager)
How to set the backup retention duration (Enterprise Manager)
How to set a fixed amount of memory (Enterprise Manager)
How to set the nested triggers option (Enterprise Manager)
How to set the priority boost option (Enterprise Manager)
How to set the recovery interval (Enterprise Manager)
How to set remote server access (Enterprise Manager)
How to enforce distributed transactions for remote procedures (Enterprise Manager)
How to set a time limit for remote queries (Enterprise Manager)
How to set the working set size option (Enterprise Manager)
How to set the two digit year cutoff option (Enterprise Manager)
How to set user connections (Enterprise Manager)
How to configure user options (Enterprise Manager)
How to configure packet size (Enterprise Manager)
How to set the query governor cost limit option (Enterprise Manager)
How to enable encryption after SQL Server has been installed (Network Utility)
How to connect to SQL Server through Microsoft Proxy Server (Setup)
How to set the polling interval (Service Manager)
How to configure a mail profile (Windows)
How to set up SQL Mail (Enterprise Manager)
How to set up SQL Agent Mail (Enterprise Manager)
How to enable the Lock Page in Memory option (Windows)
How to start the SQL Server Network Utility (Network Utility)
How to load an installed server network library (Network Utility)
How to deactivate a server network library configuration (Network Utility)
How to edit a server network library configuration (Network Utility)
How to view the installed SQL Server server network libraries (Network Utility)
Expand Minimize
This topic has not yet been rated - Rate this topic

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

SQL Server 2000

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.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.