Error – Length of LOB data to be replicated exceeds configured maximum 65536
I was working on an On Demand Transactional Replication. Initially it seemed to work fine for few tables, however all of a sudden I started getting an error saying:
“Length of LOB data (78862) to be replicated exceeds configured maximum 65536”
After searching on the web I came to know that SQL Server has a default value configured maximum length of text that can be replicated.
To get rid of this error run the following command in the SQL Server Management Studio:
EXEC sp_configure ‘max text repl size’, 2147483647