Jaa


HasIdentityNotForReplColumn 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 HasIdentityNotForReplColumn property specifies whether a table has an identity column with the NOT FOR REPLICATION option set.

Syntax

object.HasIdentityNotForReplColumn

Parts

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

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetHasIdentityNotForReplColumn(LPBOOL pRelVal);

Remarks

The HasIdentityNotForReplColumn property returns TRUE if a table contains an identity column with the NOT FOR REPLICATION option set.

The NOT FOR REPLICATION option is used by Microsoft SQL Server replication to implement ranges of identity values in a partitioned environment. The NOT FOR REPLICATION option is especially useful in transactional or merge replication when a published table is partitioned with rows from various sites.

Note

HasIdentityNotForReplColumn can be used with SQL Server 2005, SQL Server 2000, and SQL Server version 7.0.

Applies To:

ReplicationTable2 Object