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:
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:
- Start SQL Query Analyzer, and then connect to the instance of SQL Server 7.0 as a system administrator.
- On the File menu, click Open.
- 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.
- Click Open.
- 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:
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
Additional query words: DTC SQL7 SQL2KSP3 Error MSDTC MS DTC
Keywords: kbtransaction kbdtc kberrmsg kbprb KB834849
