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!