복제필드의 사이즈 제한

Posted at 2008. 3. 28. 15:02 | Posted in 데이타베이스/MSSQL


--------------------------------------------------------------------------------


Some of my text/image values were not replicated. What is the problem?


--------------------------------------------------------------------------------


Answer:

There is max text repl size server option. This option is used to specify the maximum size (in bytes) of text and
image data that can be replicated. The default value for this parameter is 65536 bytes.
So, if the size of the text/image data is more than 65536 bytes, this data will not be replicated (if 'max text repl
size' option = 65536 bytes). You can change this option by using the sp_configure system stored procedure.

This is the example to set the max text repl size to 128Kb:

sp_configure 'max text repl size', 131072
GO
RECONFIGURE WITH OVERRIDE
GO


'데이타베이스 > MSSQL' 카테고리의 다른 글

xp_cmdshell 제거  (0) 2008.06.13
MSSQL 기본튜닝  (1) 2008.04.10
MSSQL 로그파일 비우는 방법  (0) 2007.11.15
월별 연령대별 통계구하기  (0) 2007.11.01
테이블 -> insert 쿼리문 변환 스크립트  (0) 2007.01.12

//