• Article

NotForRepl Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The NotForRepl property enables or disables an IDENTITY constraint for data inserted by a replication process.

Syntax

object.NotForRepl [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write if using the Column object to create or alter a Microsoft SQL Server table. Read-only if the Column object references an existing column.

Prototype (C/C++)

HRESULT GetNotForRepl(LPBOOL pRetVal);
HRESULT SetNotForRepl(BOOL NewValue);

Remarks

If TRUE, the IDENTITY constraint is not enforced when data is added to the table by a known replication login. The replication process provides identity values.

If FALSE, the IDENTITY constraint is enforced regardless of the data source.

Applies To:

Column Object