sp_addlinkedserver from SQL Server 2005 or 2008 x64 toward SQL Server 2000 or 7 x86

You may receive an error message when you try to run distributed
queries from a 64-bit SQL Server 2005 client to a linked 32-bit
SQL Server 2000 server or to a linked SQL Server 7.0 server

http://support.microsoft.com/kb/906954
or better yet run the instcat.sql file

USE master
GO

CREATE PROCEDURE sp_tables_info_rowset_64
@table_name sysname,
@table_schema sysname = null,
@table_type nvarchar(255) = null

AS

DECLARE @Result int
--SELECT @Result = 0
SET @Result = 0

EXEC @Result = sp_tables_info_rowset 
@table_name, @table_schema, @table_type
GO

GRANT EXECUTE ON dbo.sp_tables_info_rowset_64 TO [public]
GO