RESOLUTION

loadTOCNode(1, ‘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.

ref: http://support.microsoft.com/default.aspx?scid=kb;en-us;834849