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
RECONFIGURE
 
 
Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on November 15, 2009, in Issues 'N' Resolution, Replication, SQL Server and tagged , , . Bookmark the permalink. Leave a comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: