Muokkaa

Jaa


sys.dm_repl_articles (Transact-SQL)

Applies to: SQL Server

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

Column name Data type Description
artcache_db_address varbinary(8) In-memory address of the cached database structure for the publication database.
artcache_table_address varbinary(8) In-memory address of the cached table structure for a published table article.
artcache_schema_address varbinary(8) In-memory address of the cached article schema structure for a published table article.
artcache_article_address varbinary(8) In-memory address of the cached article structure for a published table article.
artid bigint Uniquely identifies each entry within this table.
artfilter bigint ID of the stored procedure used to horizontally filter the article.
artobjid bigint ID of the published object.
artpubid bigint ID of the publication to which the article belongs.
artstatus tinyint Bitmask 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.
arttype tinyint Type 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).
wszArtdesttable nvarchar(514) Name of published object at the destination.
wszArtdesttableowner nvarchar(514) Owner of published object at the destination.
wszArtinscmd nvarchar(510) Command or stored procedure used for inserts.
cmdTypeIns int Call syntax for the insert stored procedure, and can be one of these values.

1 = CALL

2 = SQL

3 = NONE

7 = UNKNOWN
wszArtdelcmd nvarchar(510) Command or stored procedure used for deletes.
cmdTypeDel int Call syntax for the delete stored procedure, and can be one of these values.

0 = XCALL

1 = CALL

2 = SQL

3 = NONE

7 = UNKNOWN
wszArtupdcmd nvarchar(510) Command or stored procedure used for updates.
cmdTypeUpd int Call 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
wszArtpartialupdcmd nvarchar(510) Command or stored procedure used for partial updates.
cmdTypePartialUpd int Call syntax for the partial update stored procedure, and can be one of these values.

2 = SQL
numcol int Number of columns in the partition for a vertically filtered article.
artcmdtype tinyint Type 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
artgeninscmd nvarchar(510) INSERT command template based on the columns included in the article.
artgendelcmd nvarchar(510) DELETE command template, which can include the primary key or the columns included in the article, depending on the call syntax is used.
artgenupdcmd nvarchar(510) UPDATE command template, which can include the primary key, updated columns, or a complete column list depending on the call syntax is used.
artpartialupdcmd nvarchar(510) Partial UPDATE command template, which includes the primary key and updated columns.
artupdtxtcmd nvarchar(510) UPDATETEXT command template, which includes the primary key and updated columns.
artgenins2cmd nvarchar(510) INSERT command template used when reconciling an article during concurrent snapshot processing.
artgendel2cmd nvarchar(510) DELETE command template used when reconciling an article during concurrent snapshot processing.
fInReconcile tinyint Indicates whether an article is currently being reconciled during concurrent snapshot processing.
fPubAllowUpdate tinyint Indicates whether the publication allows updating subscription.
intPublicationOptions bigint Bitmap 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.

Permissions

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

Remarks

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

Permissions for SQL Server 2022 and later

Requires VIEW DATABASE PERFORMANCE STATE permission on the database.

See also

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