SQL-DMO
Replication Article Constants (SQLDMO_ARTICLE_TYPE)
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 | Article uses user-defined function execution and schema to determine source data. |
| SQLDMORep_IndexedView | 256 | Underlying object of the article is an indexed view. |
| SQLDMORep_IndexedViewLogBased | 257 | Article monitors an indexed view and the transaction log to determine source data. TransArticle object only. |
| SQLDMORep_IndexedViewLogBasedManualBoth | 263 | Article monitors an indexed view and the transaction log to determine source data. The default filter procedure is overridden. TransArticle object only. |
| SQLDMORep_IndexedViewLogBasedManualFilterProc | 259 | Article monitors an indexed view and the transaction log to determine source data. The default filter procedure is overridden. TransArticle object only. |
| SQLDMORep_IndexedViewLogBasedManualSyncView | 261 | Article monitors an indexed view and the transaction log to determine source data. The default view is overridden. TransArticle object only. |
| SQLDMORep_IndexedViewSchemaOnly | 320 | Article monitors an indexed view and schema to determine source data. |
| SQLDMORep_LogBased | 1 | Article monitors the transaction log to determine source data. |
| SQLDMORep_LogBasedManualBoth | 7 | Article monitors the transaction log to determine source data. The default view and filter procedure is overridden. |
| SQLDMORep_LogBasedManualFilterProc | 3 | Article monitors the transaction log to determine source data. The default filter procedure is overridden. |
| SQLDMORep_LogBasedManualSyncView | 5 | Article monitors the transaction log to determine source data. The default view is overridden. |
| SQLDMORep_LogBasedVerticalPartition | 6 | Article monitors the transaction log to determine source data. The source data is partitioned by column. |
| SQLDMORep_ManualFilterProc | 2 | Default filter procedure is overridden. |
| SQLDMORep_ManualSyncView | 4 | Default view is overridden. |
| SQLDMORep_Max | 320 | SQLDMORep_SerializableProcExecution. |
| SQLDMORep_Min | 0 | Not set or an error condition. |
| SQLDMORep_ProcExecution | 8 | Article uses stored procedure execution to determine source data. |
| SQLDMORep_ProcSchemaOnly | 32 | Article uses stored procedure execution and schema to determine source data. |
| SQLDMORep_SerializableProcExecution | 24 | Article uses stored procedure execution to determine source data. The stored procedure is executed within a serializable transaction. |
| SQLDMORep_TableBased | 10 | Article monitors a table to determine replicated data. |
| SQLDMORep_ViewSchemaOnly | 64 | Article monitors a view and schema to determine source data. |