By default, the database option verify_all_columns is Off. When it is set to Off, only those columns that are updated are checked. When the verify_all_columns option is set to On, then:
All columns are verified on replicated UPDATE statements.
A RESOLVE UPDATE trigger is fired whenever any column is different.
The size of messages is bigger, because more information is sent for each UPDATE statement.
You can set the verify_all_columns option either for the PUBLIC group or just for the user contained in the SQL Remote connection string. See verify_all_columns option [SQL Remote].
When the verify_all_columns option is set on the consolidated database before the remote databases are extracted, then the verify_all_columns option on the remote databases is set by Extraction utility (dbxtract) and the Extract Database Wizard.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|