Replication Article Constants (SQLDMO_ARTICLE_TYPE)
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.
Replication article constants describe the source of data for, and the behavior of, a Publisher on transactional or merge articles.
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. It 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 and the default view are overridden. It 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 is overridden. It 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 is overridden. It 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 are overridden. |
SQLDMORep_/LogBasedManualFilterProc |
3 |
The article monitors the transaction log to determine source data. The default filter procedure is overridden. |
SQLDMORep_/LogBasedManualSyncView |
5 |
The article monitors the transaction log to determine source data. The default view is overridden. |
SQLDMORep_/LogBasedVerticalPartition |
6 |
The article monitors the transaction log to determine source data. The source data is partitioned by column. |
SQLDMORep_ManualFilterProc |
2 |
The default filter procedure is overridden. |
SQLDMORep_ManualSyncView |
4 |
The default view is 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 executed 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 a schema to determine source data. |