Distributed-Transaction Error in SQL Server 2000 SP3 Resolved

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).

ITPro Today

April 28, 2004

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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

   http://support.microsoft.com/?kbid=834849

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like