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.




2 comments:

  1. Great article its very useful.

    We can also submit our .net related article links on http://www.dotnettechy.com to improve traffic

    ReplyDelete
  2. Great article :) its very usefull

    We can also submit our .net related article link on http://www.dotnettechy.com to increase traffic

    This is a community of .Net developers joined together to find solutions, to learn, to teach, to find interview questions and answers, to find .net website / blog collection

    ReplyDelete

Share This