JoinUniqueKey Property

SQL-DMO

SQL-DMO

JoinUniqueKey Property

The JoinUniqueKey property configures join clause interpretation for merge replication articles horizontally partitioned by criteria established in a second article.

Applies To
MergeSubsetFilter Object  
Syntax

object.JoinUniqueKey [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetJoinUniqueKey(LPBOOL pRetVal);

HRESULT SetJoinUniqueKey(BOOL NewValue);

Remarks

When TRUE, a join to the article specified by the JoinArticleName property is based on a unique value.

When FALSE, joining for the article is not based on a unique value.

Note  If an application sets JoinUniqueKey after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.