Publication.EnumArticles Method
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
'Usage
Dim instance As Publication
Dim returnValue As ArrayList
returnValue = instance.EnumArticles()
public ArrayList EnumArticles()
public:
ArrayList^ EnumArticles()
member EnumArticles : unit -> ArrayList
public function EnumArticles() : ArrayList
Return Value
Type: System.Collections.ArrayList
An ArrayList of TransArticle or MergeArticle objects.
Exceptions
| Exception | 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).