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
Solution:
There are two solutions for this problem
Length of LOB data (583669) to be replicated exceeds configured maximum 65536
Solution:
There are two solutions for this problem
- using TSQL
- sp_configure 'max text repl size', '2147483647'
GO
RECONFIGURE - 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.