Articles that may help:

http://blog.sqlauthority.com/2007/05/04/sql-server-fix-error-msg-7311-level-16-state-2-line-1-cannot-obtain-the-schema-rowset-dbschema_tables_info-for-ole-db-provider-sqlncli-for-linked-server-linkedservername/

http://support.microsoft.com/kb/906954

more specifically the 64bit sql2005 system is looking for this system stored proc in the 32bit sql 2000 system.

http://www.errorhelp.com/search/details/68911/msg-7311-level-16-state-2-line-1-cannot-obtain-the-schema-rowset-dbschema_tables_info-for-ole-db-provider-sqlncli-for-linked-server-xxxxxx-the-provider-supports-the-interface-but-returns-a