Turns off triggers in the Adaptive Server.
Creates an instance of an rs_triggers_reset function string for a user-created base function-string class.
create function string rs_triggers_reset for sqlserver2_function_class output language 'set triggers off'
By default, the rs_triggers_reset function is executed for the DSI connection to a standby database, and is not executed for any other DSI connection.
rs_triggers_reset has function-string-class scope.
During installation, Replication Server creates an initial rs_triggers_reset function string for the system-provided function-string classes.
Standby database connections always use the system-provided class rs_default_function_class, which cannot be modified. For any other database connection, you do not need to create a function string for the rs_triggers_reset function, unless:
The database connection uses a user-created base function-string class, and
You want to set the dsi_keep_triggers configuration parameter to “off” for the connection.
Create an rs_triggers_reset function string at the Replication Server that is the primary site for the class.
Setting dsi_keep_triggers to “off” for a database connection to execute rs_triggers_reset when the connection is established. The dsi_keep_triggers default is “off” for standby databases, and “on” for replicate databases. Use the alter connection or configure connection command to change this setting.