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

SELECT INTO failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Sou..

by ㏈ª ☞ β┖υΕJini.κR 2012. 5. 10.

 



Error messages:
SELECT INTO failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Source: MSSQLServer, Error number: 1934)
Get help: http://help/1934
SELECT INTO failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Source: MSSQLServer, Error number: 1934)
Get help: http://help/1934


게시자 서버의 UNC 폴더에서 복제 관련 *.sch 들어 가서 SET ANSI_PADDING OFF 에서 ON 으로 변경 하면 됩니다.