when insert length of lob data to be replicated exceeds configured maximum 65536

Question

Hi,

I am trying to insert value for the column of datatype image in sql server. I am getting the following error

{"Length of LOB data (70823) to be replicated exceeds configured maximum 65536.
The statement has been terminated."} .

The data length is less than 2 MB.

What is the problem?

Thanks, P.Gopalakrishnan.

Answer 1

You can run:

sp_configure 'max text repl size', 2147483647

This will up the maximum size, letting the large LOBs be replicated.

Answer 2

Don't forget to run RECONFIGURE after running sp_configure so that your changes can take effect