복제필드의 사이즈 제한

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

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