User's Manual

Chapter 14. Utilities and Options Reference
relationships” on page 164.
Verify_threshold option 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. The default setting is 1000.
This option keeps the size of SQL Remote messages down, but has the
disadvantage that conflicting updates of long values are not detected.
Verify_all_columns option The default setting is OFF. When set to ON,
messages containing updates published by the local database are sent with
all column values included, and a conflict in any column triggers a
RESOLVE UPDATE trigger at the subscriber database.
The extraction utility for Adaptive Server Enterprise sets the public option in
remote Adaptive Server Anywhere databases to match the setting in the
Adaptive Server Enterprise database.
Examples ♦ The following statement sets the Verify_all_columns option to OFF in
Adaptive Server Anywhere, for all users:
SET OPTION PUBLIC.Verify_all_columns = ’OFF’
♦ The following statements set the Verify_all_columns option to OFF in
Adaptive Server Enterprise:
exec sp_remote_option Verify_all_columns, ’OFF’
go
In Adaptive Server Enterprise, replication options are used only by
SQL Remote.
319