SQL-DMO
PreCreationMethod Property
The PreCreationMethod property controls Subscriber replication object changes when article synchronization occurs.
Applies To
| MergeArticle Object | TransArticle Object |
Syntax
object.PreCreationMethod [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies a row modifying action at the Subscriber as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetPreCreationMethod(
SQLDMO_PREARTICLE_TYPE* pRetVal);
HRESULT SetPreCreationMethod(
SQLDMO_PREARTICLE_TYPE NewValue);
Settings
| Constant | Value | Description |
|---|---|---|
| SQLDMOPreArt_DeleteRows | 2 | Perform a logged delete prior to synchronization. |
| SQLDMOPreArt_DropTable | 1 | Drop and recreate table to synchronize. |
| SQLDMOPreArt_None | 0 | Do nothing prior to synchronization. |
| SQLDMOPreArt_TruncateTable | 3 | Perform a bulk-logged delete prior to synchronization. |
Remarks
If an application sets PreCreationMethod after the initial snapshot has been created, a new snapshot must be generated and reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and distribution or merge agent run.