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