• Article

JoinUniqueKey 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 JoinUniqueKey property configures join clause interpretation for merge replication articles horizontally partitioned by criteria established in second articles.

Syntax

object
.JoinUniqueKey [=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

Prototype (C/C++)

HRESULT GetJoinUniqueKey(LPBOOL pRetVal);
HRESULT SetJoinUniqueKey(BOOL NewValue);

Remarks

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

If 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.

Applies To:

MergeSubsetFilter Object