Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000

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

Photo by John Barkiple on Unsplash.