Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Question

Here is a related question.

Why do I get this error even when I have not installed SQL Server replication ? The strangest thing is, when I run the fix

sp_configure 'max text repl size', 2147483647
Go
RECONFIGURE
GO

it works and I no longer get this error

I've suggested CDC as one possible answer. If it's not that, it might be worth listing anything that's been switched on on your server instance that isn't on by default on SQL Server - e.g. Mirroring, snapshot isolation, etc, and anything other than the database instance - e.g. integration services, analysis services, etc. — Damien_The_Unbeliever, Aug 09 '10 at 14:53
Possible duplicate of [when insert length of lob data to be replicated exceeds configured maximum 65536](http://stackoverflow.com/questions/925824/when-insert-length-of-lob-data-to-be-replicated-exceeds-configured-maximum-65536) — Jim G., Feb 14 '17 at 16:43

score 21 · Accepted Answer · answered Aug 09 '10 at 14:50

21

Are you using Change Data Capture?

This option applies to transactional replication and Change Data Capture

answered Aug 09 '10 at 14:50

score 15 · Answer 2 · edited Jul 19 '13 at 08:39

15

The following steps should be performed:

edited Jul 19 '13 at 08:39

answered May 08 '12 at 23:56

Yam Chemoriya

score 1 · Answer 3 · answered Jul 08 '20 at 11:41

1

Go to Management Studio then follow below steps

Right-clicking the server -> Properties -> Advanced tab -> Miscellaneous -> Change Max Text Replication Size to (-1) -> Click OK

answered Jul 08 '20 at 11:41

MwarukaSon

3 Answers3