sp_helparticle (Transact-SQL)

Displays information about an article. This stored procedure is executed at the Publisher on the publication database. For Oracle Publishers, this stored procedure is executed at the Distributor on any database.

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_helparticle [ @publication = ] 'publication' 
    [ , [ @article = ] 'article' ]
    [ , [ @returnfilter = ] returnfilter ]
    [ , [ @publisher = ] 'publisher' ]
    [ , [ @found = ] found OUTPUT ]

Arguments

  • [ @publication =] 'publication'
    Is the name of the publication. publication is sysname, with no default.
  • [ @article=] 'article'
    Is the name of an article in the publication. article is sysname, with a default of %. If article is not supplied, information on all articles for the specified publication is returned.
  • [ @returnfilter=] returnfilter
    Specifies whether the filter clause should be returned. returnfilter is bit, with a default of 1, which returns the filter clause.
  • [ @publisher= ] 'publisher'
    Specifies a non-Microsoft SQL Server publisher. publisher is sysname, with a default of NULL.

    Note

    publisher should not be specified when requesting information on an article published by a SQL Server Publisher.

  • [ @found= ] found OUTPUT
    Internal use only.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name Data type Description

article id

int

ID of the article.

article name

sysname

Name of the article.

base object

nvarchar(257)

Name of the underlying table represented by the article or stored procedure.

destination object

sysname

Name of the destination (subscription) table.

synchronization object

nvarchar(257)

Name of the view that defines the published article.

type

smallint

The 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).

status

tinyint

Can be the & (Bitwise AND) result of one or more or these article properties:

0x00 = For internal use only.

0x01 = Article is active.

0x08 = Include the column name in insert statements.

0x16 = Use parameterized statements.

0x32 = Use parameterized statements and include the column name in insert statements.

filter

nvarchar(257)

Stored procedure used to horizontally filter the table. This stored procedure must have been created using FOR REPLICATION clause.

description

nvarchar(255)

Descriptive entry for the article.

insert_command

nvarchar(255)

The replication command type used when replicating inserts with table articles. For more information, see Specifying How Changes Are Propagated for Transactional Articles.

update_command

nvarchar(255)

The replication command type used when replicating updates with table articles. For more information, see Specifying How Changes Are Propagated for Transactional Articles.

delete_command

nvarchar(255)

The replication command type used when replicating deletes with table articles. For more information, see Specifying How Changes Are Propagated for Transactional Articles.

creation script path

nvarchar(255)

Path and name of an article schema script used to create target tables.

vertical partition

bit

Is whether vertical partitioning is enabled for the article; where a value of 1 means that vertical partitioning is enabled.

pre_creation_cmd

tinyint

Precreation command for DROP TABLE, DELETE TABLE, or TRUNCATE TABLE.

filter_clause

ntext

WHERE clause specifying the horizontal filtering.

schema_option

binary(8)

Bitmap of the schema generation option for the given article. For a complete list of schema_option values, see sp_addarticle.

dest_owner

sysname

Name of the owner of the destination object.

source_owner

sysname

Owner of the source object.

unqua_source_object

sysname

Name of the source object, without the owner name.

sync_object_owner

sysname

Owner of the view that defines the published article. .

unqualified_sync_object

sysname

Name of the view that defines the published article, without the owner name.

filter_owner

sysname

Owner of the filter.

unqua_filter

sysname

Name of the filter, without the owner name.

auto_identity_range

int

Flag indicating if automatic identity range handling was turned on at the publication at the time it was created. 1 means that automatic identity range is enabled; 0 means it is disabled.

publisher_identity_range

int

Range size of the identity range at the Publisher if the article has identityrangemanagementoption set to auto or auto_identity_range set to true.

identity_range

bigint

Range size of the identity range at the Subscriber if the article has identityrangemanagementoption set to auto or auto_identity_range set to true.

threshold

bigint

Percentage value indicating when the Distribution Agent assigns a new identity range.

identityrangemanagementoption

int

Indicates the identity range management handled for the article.

fire_triggers_on_snapshot

bit

Is if replicated user triggers are executed when the initial snapshot is applied.

1 = user triggers are executed.

0 = user triggers are not executed.

Remarks

sp_helparticle is used in snapshot replication and transactional replication.

Permissions

Only members of the sysadmin fixed server role, the db_owner fixed database role, or the publication access list for the current publication can execute sp_helparticle.

Example

DECLARE @publication AS sysname;
SET @publication = N'AdvWorksProductTran';

USE [AdventureWorks]
EXEC sp_helparticle
  @publication = @publication;
GO

See Also

Reference

sp_addarticle (Transact-SQL)
sp_articlecolumn (Transact-SQL)
sp_changearticle (Transact-SQL)
sp_droparticle (Transact-SQL)
Replication Stored Procedures (Transact-SQL)

Other Resources

How to: View and Modify Article Properties (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance