Saturday, April 28, 2012 5:07 AM
now I have 2 Dbs is syncing data using replication, the article contains a few tables with XML column, and I need to config this max text repl size.
one question is that MSDN says that the value of -1 indicates no limit, then what is the difference between -1 and max size (2147483647) ?
Saturday, April 28, 2012 1:39 PM
I would say there's no difference as long as the allowed size does not get extended that second value.In future it may be possible that image type, etc. are extended to allow more than 2GB in size.
using "-1" is less error proven that writing the max size value and not all types allow 2GB see the description of the option:
A value of -1 indicates that there is no size limit, other than the limit imposed by the data type.
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.