Chapter 5 Database Options
179
6
The values have the following meanings:
♦
-1 Send messages in Version 5 format. Message Agents (both
dbremote
and
ssremote
) from previous versions of SQL Remote cannot
read messages sent in Version 6 format. You should ensure that
COMPRESSION is set to -1 until all Message Agents in your system are
upgraded to Version 6.
♦
0 No compression.
♦
1 to 9 Increasing degrees of compression. Creating messages with
high compression can take longer than creating messages with low
compression.
CONTINUE_AFTER_RAISERROR option
Controls behavior following a RAISERROR statement.
ON, OFF
ON
Deprecated option
This option is deprecated in favor of the ON_TSQL_ERROR option.
$ For more information, see "ON_TSQL_ERROR option" on
page 201.
The RAISERROR statement is used within procedures and triggers to
generate an error. When this option is set to OFF, the execution of the
procedure or trigger is stopped whenever the RAISERROR statement is
encountered.
If you set the CONTINUE_AFTER_RAISERROR switch to ON, the
RAISERROR statement no longer signals an execution-ending error. Instead,
the RAISERROR status code and message are stored and the most recent
RAISERROR is returned when the procedure completes. If the procedure
which caused the RAISERROR was called from another procedure, the
RAISERROR is not returned until the outermost calling procedure
terminates.
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...