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

user_229652 0
Viewed 38776

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

database-replication replication sql-server-2008
3 Answers

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

user_67221510
Related