Microsoft has resolved a problem that might occur when you try to run a distributed transaction on your instance of SQL Server 2000 Service Pack 3 (SP3). If the distributed transaction doesn't complete successfully, you might still receive the error message "Server: Msg 8525, Level 16, State 1, Line 1. Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." You might experience this problem if an instance of SQL Server 7.0 is configured as a linked server or as a remote server on your instance of SQL Server 2000 SP3 and if the distributed transaction involves Data Manipulation Language (DML) statements, such as an INSERT, DELETE, or UPDATE, on the tables on the linked server. To find out more about this problem and the resolution, read the Microsoft article "You may receive error message 8525 when you try to run a distributed transaction on an instance of SQL Server 2000 SP3" at
Distributed-Transaction Error in SQL Server 2000 SP3 Resolved
0 comments
Hide comments
