tags:

views:

106

answers:

1
Q: 

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

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

+1  A: 

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

Damien_The_Unbeliever  2010-08-09 14:50:09

related questions

Suggestions for replication of data from MS Sql 2005 and MySql
How do you track the time of replicated rows for Subscribers in SQL Server 2005?
How to get master-master replication with Subversion?
Which database has the best support for replication
Using OpenID as a login for my website - redundant providers
MS-SQL Server 2005: Initializing a merge subscription with alternate snapshot location
mysql replication with lots of temporary table writes
What's the best source to learn about database replication mechanisms?
MySQL triggers + replication with multiple databases.
How do I completely disable MySQL replication
File Replication Solutions
Deleting Rows from a SQL Table marked for Replication
Postgres replication
Application Level Replication Technologies
How to add a constant column when replicating a database?
Firebird database replication
SQL Server 2005 One-way Replication
I get a "An attempt was made to load a program with an incorrect format" error on a SQL Server replication project
SQL Server Merge Replication Schedule
MySQL Binary Log Replication: Can it be set to ignore errors?
How do I replicate content on a web farm
Database replication. 2 servers, Master database and the 2nd is read-only
MySQL replication: if i don't specify any databases, will log_bin log EVERYTHING?
MySQL replication for fallback scenario
Full complete MySQL database replication? Ideas? What do people do?