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:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
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
-> Continue reading Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000