HasIdentityNotForReplColumn Property

SQL-DMO

SQL-DMO

HasIdentityNotForReplColumn Property

The HasIdentityNotForReplColumn property specifies whether a table has an identity column with the NOT FOR REPLICATION option set.

Applies To
ReplicationTable2 Object  
Syntax

object.HasIdentityNotForReplColumn

Parts

object

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™ 2000 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. For more information, see Using NOT FOR REPLICATION.

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

Note