SQL Server Performance

Linked Server call locks when called from COM+

Discussion in 'SQL Server 2005 General Developer Questions' started by DStevensTN, Mar 31, 2006.

  1. DStevensTN New Member

    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.
  2. DStevensTN New Member

    We were able to resolve this issue. The Network DTC was turned off on Windows 2003.

Share This Page