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
EXEC sp_configure ‘max text repl size’, 2147483647
SSMS (excerpt from BOL):
- In Object Explorer, right-click a server and select Properties.
- Click the Advanced node.
- Under Miscellaneous, change the Max Text Replication Size option to the desired value.
No comments:
Post a Comment