JoinArticleName Property
The JoinArticleName property identifies a source article for some types of merge replication horizontal partitioning.
Applies To
MergeSubsetFilter Object |
Syntax
object.JoinArticleName [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
String identifying an existing merge replication article by name
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetJoinArticleName(SQLDMO_LPBSTR pRetVal);
HRESULT SetJoinArticleName(SQLDMO_LPCSTR NewValue);
Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.
Remarks
Use the MergeSubsetFilter object to horizontally partition data in a merge replication article when the partitioning WHERE clause is defined in a second article.
Note If an application sets JoinArticleName after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.