ArticleType Property
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The ArticleType property indicates the method used to determine source data for replication and user-overrides of default replication behaviors.
Синтаксис
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. |
Примечание |
---|
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. |