The parameter SP_OCT_REPLICATE_TRIGGER is very useful if one intends to replicate CREATE TRIGGER to the target. It facilitates trigger creation on secondary by way of SharePlex replication once it is created on primary. The parameter does have implications if set on the secondary side that happens to be a node in a two-way replication and is due to a bug. The bug only exists in SharePlex 9.1.2 or below. This bug results in CREATE TRIGGER DDLs replicate in the form of infinite loop between the nodes of an active-active replication if the nodes have the parameter SP_OCT_REPLICATE_TRIGGER set to 1.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center