Friday, July 27, 2012

Issue: Length of LOB data to be replicated exceeds configured maximum 65536


Error:
Length of LOB data (78862) to be replicated exceeds configured maximum 65536
Scenario:
We published some articles that use varchar(max) and a lot of XML data types for the columns. When we enabled replication, we got the error Length of LOB data (78862) to be replicated exceeds configured maximum 65536
Solution:
Increase the size that can be replicated. This is applicable for transactional replication only.
T-SQL: 
EXEC sp_configure ‘max text repl size’, 2147483647
SSMS (excerpt from BOL):
    1. In Object Explorer, right-click a server and select Properties.
    2. Click the Advanced node.
    3. Under Miscellaneous, change the Max Text Replication Size option to the desired value.

No comments:

Post a Comment