Controls whether messages that contain updates published by the local database are sent with all column values included.
|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|
This option is used by SQL Remote only. When it is set to On, messages that contain 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 following statement sets the verify_all_columns option to Off in SQL Anywhere, for all users:
SET OPTION PUBLIC.verify_all_columns = 'Off';