Thursday, May 3, 2012

Lengh 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 
  • 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.




Share This