What is the impact of setting "max text repl size (B)" to -1? I have a table replicated via transactional replication that is throwing this error message:


  Length of LOB data (68983) to be replicated exceeds configured
  maximum 65536.


This can be resolved by adjusting the "max text repl size (B)" SQL Configuration value from the default of 65536.

I see two options:


Adjust the value higher than required for this situation 
Set the value to "-1" which indicates no limit


My question is:  What is the downside of setting "max text repl size (B)" to -1?

I appreciate any feedback!
What is the downside of setting "max text repl size (B)" to -1?


I would not set the value to -1 (limitless). I would instead find out the max datalength of your lob data and set it accordingly with a 10% buffer. This way you have more control of what and how much gets into distribution.

I can see that in an unlikely situation, setting of -1 can cause high network latency if the blob data to be replicated is of a much larger size.