23 August 2007 - Born SQL

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

USE master

CREATE PROCEDURE sp_tables_info_rowset_64 (

@table_name SYSNAME,

@table_schema SYSNAME = NULL,

@table_type NVARCHAR(255) = NULL)

DECLARE @Result INT

SELECT @Result = 0

EXEC @Result = sp_tables_info_rowset

@table_name,

@table_schema,

@table_type

GRANT EXECUTE ON dbo.sp_tables_info_rowset_64 TO [public]

Photo by John Barkiple on
-> Continue reading Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000