ArticleType Property
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The ArticleType property indicates the method used to determine source data for replication and user-overrides of default replication behaviors.
Syntaxe
object.ArticleType [=value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer specifying replication article data source as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetArticleType(SQLDMO_ARTICLE_TYPE* pRetVal);
HRESULT SetArticleType(SQLDMO_ARTICLE_TYPE NewValue);
Settings
Constant |
Value |
Description |
|---|---|---|
SQLDMORep_/FuncSchemaOnly |
128 |
The article uses user-defined function execution and schema to determine source data. |
SQLDMORep_IndexedView |
256 |
The underlying object of the article is an indexed view. |
SQLDMORep/IndexedViewLogBased |
257 |
The article monitors an indexed view and the transaction log to determine source data. This setting applies to the TransArticle object only. |
SQLDMORep/IndexedViewLogBasedManualBoth |
263 |
The article monitors an indexed view and the transaction log to determine source data. The default filter procedure has been overridden. This setting applies to the TransArticle object only. |
SQLDMORep/IndexedViewLogBasedManualFilterProc |
259 |
The article monitors an indexed view and the transaction log to determine source data. The default filter procedure has been overridden. This setting applies to the TransArticle object only. |
SQLDMORep/IndexedViewLogBasedManualSyncView |
261 |
The article monitors an indexed view and the transaction log to determine source data. The default view has been overridden. This setting applies to the TransArticle object only. |
SQLDMORep/IndexedViewSchemaOnly |
320 |
The article monitors an indexed view and schema to determine source data. |
SQLDMORep_LogBased |
1 |
The article monitors the transaction log to determine source data. |
SQLDMORep/LogBasedManualBoth |
7 |
The article monitors the transaction log to determine source data. The default view and filter procedure have been overridden. |
SQLDMORep/LogBasedManualFilterProc |
3 |
The article monitors the transaction log to determine source data. The default filter procedure has been overridden. |
SQLDMORep/LogBasedManualSyncView |
5 |
The article monitors the transaction log to determine source data. The default view has been overridden. |
SQLDMORep/LogBasedVerticalPartition |
6 |
The article monitors the transaction log to determine source data. The source data has been partitioned by column. |
SQLDMORep/ManualFilterProc |
2 |
The default filter procedure has been overridden. |
SQLDMORep/ManualSyncView |
4 |
The default view has been overridden. |
SQLDMORep_Max |
320 |
SQLDMORep_IndexedViewSchemaOnly. |
SQLDMORep_Min |
0 |
Not set or an error condition. |
SQLDMORep/ProcExecution |
8 |
The article uses stored procedure execution to determine source data. |
SQLDMORep/ProcSchemaOnly |
32 |
The article uses stored procedure execution and schema to determine source data. |
SQLDMORep/SerializableProcExecution |
24 |
The article uses stored procedure execution to determine source data. The stored procedure is run within a serializable transaction. |
SQLDMORep_TableBased |
10 |
The article monitors a table to determine replicated data. |
SQLDMORep/ViewSchemaOnly |
64 |
The article monitors a view and schema to determine source data. |
[!REMARQUE]
If an application sets ArticleTypewith the TransArticle object after the initial snapshot has been created, a new snapshot must be generated and the reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and distribution agent run.