Alphabetical list of options
174
Controls whether any new columns with the TIMESTAMP data type that do
not have an explicit default value defined are given a default value of the
Transact-SQL timestamp value as a default. The
AUTOMATIC_TIMESTAMP option is included for Transact-SQL
compatibility. The default is OFF.
$ For more information, see "Setting options for Transact-SQL
compatibility" on page 969 of the book ASA User’s Guide.
BACKGROUND_PRIORITY option
To limit impact on the performance of connections other than the current
connection.
ON or OFF
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
If you set this option temporarily, that setting applies to the current
connection only. Different connections under the same user ID can have
different settings for this option.
OFF
When set to ON, it requests that the current connection have minimal impact
on the performance of other connections. This option allows tasks for which
responsiveness is critical to coexist with other tasks for which performance is
not as important.
BELL option [ISQL]
Controls whether the bell sounds when an error occurs.
ON, OFF
ON
Set this option according to your preference.
BLOB_THRESHOLD option
Controls the size of value that the Message Agent treats as a long object
(blob).
Description
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Default
Description
Function
To Next Page
Loading...