verify_threshold option [SQL Remote]

Controls which columns are verified when updates are replicated.

Allowed values

Integer, in bytes

Default

1000

Scope

	PUBLIC role	For current user	For other users
Allowed to set permanently?	Yes, with SET ANY USER DEFINED OPTION	Yes	Yes, with SET ANY USER DEFINED OPTION
Allowed to set temporarily?	No	No	No

Remarks

This option is used by SQL Remote only. If the data type of a column is longer than the threshold, old values for the column are not verified when an UPDATE is replicated. This keeps the size of SQL Remote messages down, but has the disadvantage that conflicting updates of long values are not detected.