Article ID: 258238
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q258238
BUG #: 57639(SQLBUG_70)
SYMPTOMS
SQL Server allows multiple connections, identified by their system process id (SPID), to enlist in the same Microsoft Distributed Transaction Coordinator (MS DTC) transaction. SQL Server limits active operations to a single SPID. Simultaneous operation attempts result in the following 3910 error message:
When the SPID attempts to engage (propagate) in the same transaction, the SPID can go to sleep and not be alerted by another thread.
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
256649 FIX: Simultaneous DTC Operations May Cause Errors
WORKAROUND
Correct the application logic to avoid the 3910 error message.
You can use the T-SQL Kill command to terminate the processes that are not responding.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
Keywords: kbbug kbpending KB258238