Linked Server call locks when called from COM+ | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Linked Server call locks when called from COM+

We have an issue where a COM+ component is calling a Stored Procedure in SQL 2000. The Stored Procedure makes a call to a Linked Server table on a 2005 box. Whenever this call is made the process permanently blocks the table. If I call the stored procedure from Query Analyzer everything returns fine. If I try to kill the blocking process it will go to 100% status from the kill 98 with statusonly command, but never actually goes away. Does anyone have any ideas?
Thanks.
We were able to resolve this issue. The Network DTC was turned off on Windows 2003.
]]>