|
|
| |
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
|
|
|
|
