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

Question

I am trying to insert a value into a 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?

Answer 1

For SQL Server 2005 or earlier you can run:

sp_configure 'max text repl size', 2147483647

For SQL Server 2008 or later you can run:

sp_configure 'max text repl size', -1

The former increases the maximum size allowed, the latter essentially says "remove the limit". Once the maximum size is increased or removed, large LOBs will be able to be replicated.

Answer 2

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