TechNet
Export (0) Print
Expand All

sys.dm_repl_articles (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about database objects published as articles in a replication topology.

Column nameData typeDescription
artcache_db_addressvarbinary(8)In-memory address of the cached database structure for the publication database.
artcache_table_addressvarbinary(8)In-memory address of the cached table structure for a published table article.
artcache_schema_addressvarbinary(8)In-memory address of the cached article schema structure for a published table article.
artcache_article_addressvarbinary(8)In-memory address of the cached article structure for a published table article.
artidbigintUniquely identifies each entry within this table.
artfilterbigintID of the stored procedure used to horizontally filter the article.
artobjidbigintID of the published object.
artpubidbigintID of the publication to which the article belongs.
artstatustinyintBitmask of the article options and status, which can be the bitwise logical OR result of one or more of these values:

 1 = Article is active.

 8 = Include the column name in INSERT statements.

 16 = Use parameterized statements.

 24 = Both include the column name in INSERT statements and use parameterized statements.

For example, an active article using parameterized statements would have a value of 17 in this column. A value of 0 means that the article is inactive and no additional properties are defined.
arttypetinyintType of article:

 1 = Log-based article.

 3 = Log-based article with manual filter.

 5 = Log-based article with manual view.

 7 = Log-based article with manual filter and manual view.

 8 = Stored procedure execution.

 24 = Serializable stored procedure execution.

 32 = Stored procedure (schema only).

 64 = View (schema only).

 128 = Function (schema only).
wszArtdesttablenvarchar(514)Name of published object at the destination.
wszArtdesttableownernvarchar(514)Owner of published object at the destination.
wszArtinscmdnvarchar(510)Command or stored procedure used for inserts.
cmdTypeInsintCall syntax for the insert stored procedure, and can be one of these values.

 1 = CALL

 2 = SQL

 3 = NONE

 7 = UNKNOWN
wszArtdelcmdnvarchar(510)Command or stored procedure used for deletes.
cmdTypeDelintCall syntax for the delete stored procedure, and can be one of these values.

 0 = XCALL

 1 = CALL

 2 = SQL

 3 = NONE

 7 = UNKNOWN
wszArtupdcmdnvarchar(510)Command or stored procedure used for updates.
cmdTypeUpdintCall syntax for the update stored procedure, and can be one of these values.

 0 = XCALL

 1 = CALL

 2 = SQL

 3 = NONE

 4 = MCALL

 5 = VCALL

 6 = SCALL

 7 = UNKNOWN
wszArtpartialupdcmdnvarchar(510)Command or stored procedure used for partial updates.
cmdTypePartialUpdintCall syntax for the partial update stored procedure, and can be one of these values.

 2 = SQL
numcolintNumber of columns in the partition for a vertically filtered article.
artcmdtypetinyintType of command currently being replicated, and can be one of these values.

 1 = INSERT

 2 = DELETE

 3 = UPDATE

 4 = UPDATETEXT

 5 = none

 6 = internal use only

 7 = internal use only

 8 = partial UPDATE
artgeninscmdnvarchar(510)INSERT command template based on the columns included in the article.
artgendelcmdnvarchar(510)DELETE command template, which can include the primary key or the columns included in the article, depending on the call syntax is used.
artgenupdcmdnvarchar(510)UPDATE command template, which can include the primary key, updated columns, or a complete column list depending on the call syntax is used.
artpartialupdcmdnvarchar(510)Partial UPDATE command template, which includes the primary key and updated columns.
artupdtxtcmdnvarchar(510)UPDATETEXT command template, which includes the primary key and updated columns.
artgenins2cmdnvarchar(510)INSERT command template used when reconciling an article during concurrent snapshot processing.
artgendel2cmdnvarchar(510)DELETE command template used when reconciling an article during concurrent snapshot processing.
fInReconciletinyintIndicates whether an article is currently being reconciled during concurrent snapshot processing.
fPubAllowUpdatetinyintIndicates whether the publication allows updating subscription.
intPublicationOptionsbigintBitmap that specifies additional publishing options, where the bitwise option values are:

 0x1 - Enabled for peer-to-peer replication.

 0x2 - Publish only local changes.

 0x4 - Enabled for non-SQL Server Subscribers.

Requires VIEW DATABASE STATE permission on the publication database to call dm_repl_articles.

Information is only returned for replicated database objects that are currently loaded in the replication article cache.

Dynamic Management Views and Functions (Transact-SQL)
Replication Related Dynamic Management Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft