Contents Index sp_remote procedure sp_remote_type procedure

SQL Remote User's Guide
  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
SR_Date_Format time-string hh:nn:ss.Ssssss
SR_Time_Format date-string yyyy/mm/dd
SR_Timestamp_Format timestamp-string yyyy/mm/dd hh:nn:ss.Ssssss
Subscribe_by_remote ON,OFF ON
Verify_threshold integer 256
Verify_all_columns ON,OFF OFF

For a complete description of these options, see SQL Remote options.

Example 

Contents Index sp_remote procedure sp_remote_type procedure