Publication.EnumArticles Method

Article
12/03/2008

Returns the articles in the publication.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Syntax

'Declaration
Public Function EnumArticles As ArrayList

public ArrayList EnumArticles ()

public:
ArrayList^ EnumArticles ()

public ArrayList EnumArticles ()

public function EnumArticles () : ArrayList

Return Value

An ArrayList of TransArticle or MergeArticle objects.

Exceptions

Exception type	Condition
ApplicationException	If the publication does not exist on the server.

Remarks

If the publication is a merge publication, the ArrayList contains MergeArticle objects. If the publication is a transactional or snapshot publication, the ArrayList contains TransArticle objects.

The EnumArticles method can only be called by members of the sysadmin fixed server role, by members of the db_owner fixed database role, or users in the publication access list (PAL) for the publication

Calling EnumArticles is equivalent to executing sp_helparticle (Transact-SQL) or sp_helpmergearticle (Transact-SQL).

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms