Attribute

EnableReplicationUser (ERU)

Purpose

Specifies whether explicit values may be inserted into IDENTITY columns defined as NOT FOR REPLICATION.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver allows explicit inserts on IDENTITY columns defined as NOT FOR REPLICATION.

If set to 0 (Disabled), the driver enforces constraints on IDENTITY columns imposed by the NOT FOR REPLICATION flag.

Notes

  • To provide greater control to an application, enable replication user functionality may be enabled by setting the SQL_COPT_REPLICATION_USER connection attribute (numeric value 1080) to 1 (Enabled). If different values are specified for the Enable Replication User option and the SQL_COPT_REPLICATION_USER attribute, driver behavior is determined by the value of the SQL_COPT_REPLICATION_USER attribute.

Default

0 (Disabled)

GUI Tab

Advanced tab

See also