The SyncType property controls subscription agent behavior when subscription synchronization is required.
| DistributionSubscription Object | MergeSubscription Object |
| MergePullSubscription Object | TransSubscription Object |
object.SyncType [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying subscription agent synchronization behavior as described in Settings |
| Constant | Value | Description |
|---|---|---|
| SQLDMOSubSync_Auto | 1 | Subscription agent will synchronize the subscription automatically. |
| SQLDMOSubSync_Default | 1 | SQLDMOSubSync_Auto. |
| SQLDMOSubSync_Manual | 0 | Maintained for backward compatibility. |
| SQLDMOSubSync_None | 2 | Subscription agent will not attempt publication synchronization. User interaction necessary to ensure synchronization. |
Long, enumerated
Read/write
HRESULT GetSyncType(SQLDMO_SUBSYNC_TYPE FAR* pRetVal);
HRESULT SetSyncType(SQLDMO_SUBSYNC_TYPE NewValue);