Lengh of LOB data to be replicated exceeds configured maximum 65536

added by sagitariusmzi
5/3/2012 12:00:43 AM

-1 Kicks, 122 Views

Whenever we 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 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.


0 comments