PowerExchange queries each registered table to determine if the insert, update, and delete triggers exist. If a trigger does not exist for a table, PowerExchange creates it. Alternatively, you can create the triggers in the tables registered for change data capture manually. If you choose to create the triggers manually, the user ID connected to the source database must have WRITE permission for the PKLOG table.

If a table is removed from the list of registered tables, PowerExchange removes the trigger that it automatically created from that table. You can list the triggers to verify that PowerExchange removed the triggers from the removed source table or you can drop the triggers manually from the removed source table.