In addition it should be SQL 2005 64 bit edition accessing SQL 2000 32 bit edition.

Easiest solution is:

On SQL 2000 side run the following script:

create procedure sp_tables_info_rowset_64 @table_name sysname, @table_schema sysname = null, @table_type nvarchar(255) = null as declare @Result intselect @Result = 0exec @Result = sp_tables_info_rowset @table_name, @table_schema, @table_type