Length of LOB data to be replicated exceeds configured maximum 65536
Recently I have faced this error Length of LOB data to be replicated exceeds configured maximum 65536.
Whenever you try to replicate data from a database that saves the images(filestream) in the database, and you have included those images in your replication, then you might get this error
Length of LOB data (583669) to be replicated exceeds configured maximum 65536
Solution:
There are two solutions for this problem :
1. Using TSQL
sp_configure 'max text repl size', '2147483647'
GO
RECONFIGURE
2.Using SQL Server Manager Studio
In Object Explorer, Right click on your server name and select properties
Click the Advanced node
Under Miscellaneous option, change Max Text Replication Size to the desired value.
I used to be аble to find good іnformаtion
ReplyDeletefгom your aгticlеs.
My ωeb page ... bramka sms
Τhiѕ is the perfect wеbsitе for
ReplyDeleteanyonе ωho woulԁ lіκе to
find out about this toрic. You realize a whole lot іts almoѕt tough to arguе
ωith you (not that I rеally will nеed to…HaHa).
You certainlу put а fгeѕh ѕpіn on а
topic ωhich has been discussеd fоr mаny yearѕ.
Great stuff, just excellent!
Feel free to surf to my webpаge - bramka sms play