ArticleType 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 ArticleType property indicates the method used to determine source data for replication and user-overrides of default replication behaviors.
Syntax
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. |
Note
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.