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

(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

Author: randolph

Randolph West is a Microsoft Data Platform MVP, and has worked with SQL Server since the late 1990s. When not consulting, he can be seen acting on the stage and screen, or doing voices for independent video games. Connect with Randolph on Google+ or Twitter.