Microsoft KB Archive/834849

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

Article ID: 834849

Article Last Modified on 3/19/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3
 * Microsoft SQL Server 7.0 Standard Edition

-



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 \install folder.
 * 1) Click Open.
 * 2) 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.

