Microsoft Distributed Transaction Coordinator(MS DTC) is responsible for transactions across a network of Windows NT and Windows 98-based systems.Whwn you install SQL Server,the MS DTC service is automatically added to the Services application in the control panel.With the help of MS DTC,SQL Server can atomically update dat,through a transaction that resides on two or more SQL Servers.

In SQL Server, MS DTC works as a service with a Windows NT user account.To start and stop MS DTC Service,you can use the Services program in the Control Panel,the Service Manager application,and SQL Server Enterprise Manager.

By using SQL Server Enterprise Manager,you can:

1>Start and stop MS DTC

2>View all the running transactions along with the status of each transaction.

3>View event log information as well as MS DTC trace information by opening the MS DTC Trace window.In addition,you can filter the displayed information based on the security level.

Thanks and Regards


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: