linked server issue on sql 2000 sp4

Hi skc_chat,

It seems this issue have been fixed after install Microsoft SQL Server 2000 Service Pack 4. Please refer to the following article:

FIX: "Connection is busy with results for another command" error message occurs when you run a linked server query: http://ift.tt/NBtthC

Please try to install the latest CU for SQL Server 2000 SP4 to see if this helps. We can find it from the link below:

http://ift.tt/1mlEDS6

In addition, Microsoft have ended SQL Server 2000 support. Please consider upgrading to latest version of SQL Server as soon as possible.

Upgrading to SQL Server 2008 R2: http://ift.tt/NBtuSL
Upgrade to SQL Server 2012: http://ift.tt/NBttya

Regards,

---

Elvis Long

TechNet Community Support