Changes an existing error class by copying error actions from another error class.
alter error class error_class set template to template_error_class
The error class to modify.
Use this clause to update an error class based on another error class. alter error class copies the error actions from the template error class to the existing error class.
Changes my_error_class using rs_sqlserver_error_class as the basis:
alter error class my_error_class set template to rs_sqlserver_error_class
Use the alter error class command and another error class as a template to alter error classes. alter error class copies error actions from the template error class to the error class you want to alter, and overwrites error actions which have the same error code.
You can assign non-Adaptive Server error classes to specific connections on non-Adaptive Server replication databases using the create connection and alter connection commands.
When Replication Server establishes a connection to a non-Adaptive Server replicate server, Replication Server verifies if the option to return native error codes from the non-Adaptive Server replicate server is enabled for the connection. If the option is not enabled, Replication Server logs a warning message that the connection works but error action mapping may not be correct.
For a list of non-Adaptive Server error classes, see Table 3-23. For more information about non-Adaptive Server replication error classes, see the Replication Server Administration Guide Volume 1.