You may receive error message 8525 when you try to run a distributed transaction on an instance of SQL Server

Article translations Article translations
Article ID: 834849 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you try to run a distributed transaction on your instance of Microsoft SQL Server 2000 Service Pack 3 (SP3), the distributed transaction may not be completed successfully. You may receive the following 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.
This problem may occur if both of the following conditions are true:
  • 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.
  • The distributed transaction involves Data Manipulation Language (DML) statements, such as an INSERT, DELETE, or UPDATE, on the tables on the linked server.

RESOLUTION

To resolve this problem, you must upgrade the catalog stored procedures on each instance of SQL Server 7.0 that is configured as a linked server and that is participating in the distributed transaction. You can upgrade the catalog stored procedures on your instance of SQL Server 7.0 by running the Instcat.sql SQL script file that is included with the SQL Server 2000 SP3 setup files.

Note To upgrade the catalog stored procedures, you must have access to the setup files for SQL Server 2000 SP3.

To upgrade the catalog stored procedures, follow these steps for each instance of SQL Server 7.0:
  1. Start SQL Query Analyzer, and then connect to the instance of SQL Server 7.0 as a system administrator.
  2. On the File menu, click Open.
  3. In the Open Query File dialog box, locate and then click the Instcat.sql SQL script file from the SQL Server 2000 SP3 setup files.

    Note By default, the Instcat.sql script file exists in the Full path of the setup files for SQL Server 2000 SP3\install folder.
  4. Click Open.
  5. In SQL Query Analyzer, click Execute on the Query menu.

MORE INFORMATION

The Microsoft SQL Server ODBC driver uses a set of system stored procedures that are known as catalog stored procedures to obtain information from the SQL Server system catalog. Each version of the Microsoft SQL Server ODBC driver is developed to work with a specific version of the catalog stored procedures. The Instcat.sql file that is included with SQL Server 2000 SP3 contains updates to the catalog stored procedures. Therefore, if you are working with an instance of SQL Server 2000 SP3, you must upgrade the catalog stored procedures for your instance of SQL Server 7.0 to make sure that the Microsoft SQL Server ODBC driver functions correctly.

Note When you upgrade the catalog stored procedures, it does not affect the operation of older SQL Server clients.

REFERENCES

For more information about distributed transactions, see the following topics in SQL Server Books Online:
  • Distributed transactions architecture
  • Distributed queries and distributed transactions

For more information about the catalog stored procedures, visit the following Microsoft Web sites:
http://msdn2.microsoft.com/en-us/library/aa236928(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa215459(SQL.80).aspx
For additional information about other problems that may occur when you use Microsoft Distributed Transaction Coordinator (MS DTC), click the following article number to view the article in the Microsoft Knowledge Base:
306212 INF: Troubleshooting linked server error 7391

Properties

Article ID: 834849 - Last Review: March 19, 2007 - Revision: 3.3
APPLIES TO
  • Microsoft SQL Server 2000 Service Pack 3
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbtransaction kbdtc kberrmsg kbprb KB834849

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com