sa_server_option system procedure

Function

Overrides a server option while the server is running.

Syntax

sa_server_option ( opt, val )

Description

See sa_server_option system procedure" in SQL Anywhere Server – SQL Reference.

The OptionWatchList option has a unique definition in Sybase IQ:

OptionWatchList Specifies a comma-separated list of database options that you want to be notified about, or have the database server return an error for, when they are set. The string length is limited to 128 bytes. By default, it is an empty string.

CALL dbo.sa_server_option( 'OptionWatchList')

You can view the current setting for this property by executing the following query:

SELECT DB_PROPERTY( 'OptionWatchList' );