March 5, 2010 at 5:59 am
Hi All
What is functions of both Microsoft Distributed Transaction Coordinator & Linked Servers
Why We start MSDTC Services ?
If for distributed queries , then what is use of liniked servers
Thanks
Ghanshyam
March 5, 2010 at 7:24 am
MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent COMMIT TRANSACTION or ROLLBACK TRANSACTION statement is issued for the session, the controlling instance requests that MS DTC manage the completion of the distributed transaction across all of the instances involved.
IF you are using Distributed Transactions you should enable this service and grant necessary permissions on top of rebuilding on a Clustered instance when it is necessary as per KBA294209 link. Books Online (BOL) refers the underline activities of this as: Normally, all transaction management commands are sent through the SQL Native Client ODBC driver to the server. The application starts a transaction by calling SQLSetConnectAttr with the autocommit mode turned off. The application then performs the updates comprising the transaction and calls SQLEndTran with either the SQL_COMMIT or SQL_ROLLBACK option.
So if you are not using distributed transactions, making use of linked servers remote procedures or SQL not installed on a clustered instance, then no need to worry about MSDTC service on the server. Otherwise you need to set it up properly.Further information read it http://blogs.msdn.com/sqlblog/archive/2006/10/06/MSDTC-and-SQL-Server-on-a-cluster.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply