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.