ERROR MESAGGE:
“Length of LOB data (xxxxx) to be replicated exceeds configured maximum 65536. The statement has been terminated.”
EXPLANATION:
You may experience such an error on a system where you are performing the replication process.
The default number used to replicate LOB data is 65536. You may experience this error if you are performing the Replication with a larger data than this.
SOLUTION:
You can change the maximum value of this system setting if you enter and run the following command to Query Editor. So you get rid of this problem.
1 2 3 | sp_configure 'max text repl size', '9000000' GO RECONFIGURE |
The number “9000000” is an example.