Show TOC

drop error classLocate this document in the navigation structure

Drops an error class and any actions associated with it.

Syntax
drop [replication server] error class <error_class>
Parameters
replication server

Indicates that the error class is a Replication Server error class and not a data server error class.

error_class

The name of the error class to drop.

Examples
Example 1

Drops the <pubs2_db_err_class> error class from the Replication Server. Also, drops any error actions that were assigned for the <pubs2_db_err_class> error class:

drop error class pubs2_db_err_class
Example 2
Drops the <sydney_rs_err_class> Replication Server error class from the Replication Server. Also, drops any error actions that were assigned for the <sydney_rs_err_class> error class:
drop replication server error class sydney_rs_err_class
Usage
  • Use the drop error class command to remove an error class. When an error class is dropped, all actions assigned for it are also dropped.

  • You execute drop error class at the Replication Server where the error class was created.

  • You cannot drop:
    • The <rs_sqlserver_error_class> error class.

    • The <rs_repserver_error_class> error class.

    • An error class that is in use with a database

  • To change the primary site for an error class, use the move primary of error class command.

  • Replication Server distributes information about the dropped class to qualifying sites through the replication system. The changes do not appear immediately at all such sites because of normal replication system latency.

Permissions

drop error class requires “sa” permission.