Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 18. Command Reference for Adaptive Server Enterprise       

sp_remote_option procedure

Purpose 

To set a SQL Remote option.

Syntax 

sp_remote_option option_name, option_value

Argument	Description
option_name	The name of one of the SQL Remote options
option_value	The value to which the option is set.

See also 

SQL Remote options.

Description 

The SQL Remote options provide control over replication behavior. The following options are available in Adaptive Server Enterprise:

OPTION	VALUES	DEFAULT
Blob_threshold	Integer, in K	256
Compression	-1 to 9	6
Delete_old_logs	ON, OFF	OFF
Qualify_owners	ON, OFF	OFF
Quote_all_identifiers	ON, OFF	OFF
Replication_error	procedure-name	NULL
Subscribe_by_remote	ON,OFF	ON
Verify_threshold	integer	256
Verify_all_columns	ON,OFF	OFF

A complete description of these options is provided in SQL Remote options.

Example 

• The following statement sets the Verify_all_columns option to OFF, so that old values of update statements applied by the Message Agent are not checked automatically for all columns.

  sp_remote_option Verify_all_columns, OFF
  go