본문 바로가기
㏈ª By β┖υΕJini/MS-SQL

SQL 2008 R2 64bit To SQL 2000 32Bit Linked Server Error

by ㏈ª ☞ β┖υΕJini.κR 2011. 8. 30.


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