sp_addlinkedserver from SQL Server 2005 or 2008 x64 toward SQL Server 2000 or 7 x86

Author Johnny Josefsson on September 25, 2010 | Print | Bookmark
You may receive an error message when you try to run distributed
queries from a 64-bit SQL Server 2005 client to a linked 32-bit
SQL Server 2000 server or to a linked SQL Server 7.0 server
http://support.microsoft.com/kb/906954
or better yet run the instcat.sql file
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
SET @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

Was this article helpful?

Yes No
Attachments

Category: Windows, MS SQL

Last updated on September 26, 2010 with 1584 views