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.