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

sql-server-2008 replication database-replication
ram picture ram · Aug 9, 2010 · Viewed 35.9k times · Source

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

Answer

Damien_The_Unbeliever picture Damien_The_Unbeliever · Aug 9, 2010

Are you using Change Data Capture?

From How to: Configure the max text repl size Option (SQL Server Management Studio)

This option applies to transactional replication and Change Data Capture

Related questions

Pause SQL server replication temporarily

We have a transactional replication setup using 3 SQL Servers, 1st as publisher, 2nd as distributor, and 3rd as subscriber. We have an activity to change the location of the replicated DB (subscriber) using de-attach and attach method. During this activity, …

Read More
Why SQL Server doesn't allow to remove a Distributor exactly after Configuration?

I Configured a distribution in SQL Server 2008 using both Wizard and T-SQL but after it when I want to remove it Using Wizard (right clicking on Replication and choosing 'Disable Publishing and Distribution...') or executing following command with and …

Read More
How do I check SQL replication status via T-SQL?

I want to be able to check the status of a publication and subscription in SQL Server 2008 T-SQL. I want to be able to determine if its okay, when was the last successful, sync, etc.. Is this possible?

Read More