(Originally posted on my personal blog.)
For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been plaguing us for a while now, and today I made it work, thanks entirely to uber1024.
Add this to your SQL Server 2000 instance:
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 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