FIX: Error message when you run a stored procedure that references a linked server that is linked to the local server itself in SQL Server 2005: "Transaction context in use by another session"
The following pages were recently modified.
Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise X64 Edition
Notification Contents: New and All Modifications
FIX: Error message when you run a stored procedure that references a linked server that is linked to the local server itself in SQL Server 2005: "Transaction context in use by another session"
http://support.microsoft.com/kb/947486/en-US