Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server [linked_server_name]

just got this error when try to execute query against LinkServer (SQL 2000) from SQL 2005

eventhough the link can create but i can't do 4 parts query
select * from LINKED.DB.DBO.TABLE

the problem because SQL 2000 needs to run certain SP that not exists in master so the LINK query can run

create procedure sp_tables_info_rowset_64      @table_name sysname,      @table_schema     sysname = null,        @table_type nvarchar(255) = nullasdeclare @Result int set @Result = 0exec @Result = sp_tables_info_rowset @table_name,@table_schema, @table_type

this solution originally POST by Marek Adamczuk

until then