| title | sys.dm_repl_articles (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql | ||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 794d514e-bacd-432e-a8ec-3a063a97a37b | ||||
| author | stevestein | ||||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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. |
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)