64bit Sql Server 서버에서 32Bit 서버 연결 할때 아래와 같은 에러가 발생 합니다.
OLE DB provider "SQLNCLI10" for linked server "XXXXXX" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator
해결 방법
USE MASTER;
CREATE PROCEDURE SP_TABLES_INFO_ROWSET_64
@TABLE_NAME SYSNAME,
@TABLE_SCHEMA SYSNAME = NULL,
@TABLE_TYPE NVARCHAR(255) = NULL
AS
DECLARE @RESULT INT SET @RESULT = 0
EXEC @RESULT = SP_TABLES_INFO_ROWSET @TABLE_NAME, @TABLE_SCHEMA, @TABLE_TYPE
MS 관련 링크
http://support.microsoft.com/?id=906954
