SQL Server Performance Forum – Threads Archive

Avoiding the usage of DTC service

Hello I am running an script and the following sentence throws and error because the DTC service is not running in the Remote Server: insert into MyLocalTable
execute synonym_MyRemoteProcedure @SomeParameter Since a transaction is not declared within the script, why is the DTC required?
How can I avoid the usage of the DTC? Is there a way to say "this code is not within a distributed transaction"? Thanks a lot.

You can use SSIS/dts package to do this without DTC interference..
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks for your reply. The described sentenced is part of a bigger stored procedure with a certain logic, and I would rather not use DTS of SSIS. The usage of DTC is unavoidable?

Yes, you need DTC… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

For linked server execution DTC (MSDTC) is required and as suggested if you are using DTS or SSIS you need not. SO in this case ensure the DTC service is started successfully. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

So corrected from DTS to DTC [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />], thats what confused me first. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</center>

]]>