Header Ads

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.


2 comments:

  1. I used to be аble to find good іnformаtion
    fгom your aгticlеs.

    My ωeb page ... bramka sms

    ReplyDelete
  2. Τhiѕ is the perfect wеbsitе for
    anyonе ω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

    ReplyDelete

Powered by Blogger.