ReplicationDatabase.EnumTransPublications Method
Returns a list of transactional and snapshot publications that use the database.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public Function EnumTransPublications As ArrayList
'Usage
Dim instance As ReplicationDatabase
Dim returnValue As ArrayList
returnValue = instance.EnumTransPublications()
public ArrayList EnumTransPublications()
public:
ArrayList^ EnumTransPublications()
member EnumTransPublications : unit -> ArrayList
public function EnumTransPublications() : ArrayList
Return Value
Type: System.Collections.ArrayList
An ArrayList of TransPublication objects.
Exceptions
| Exception | Condition |
|---|---|
| ApplicationException | When the database does not exist. |
Remarks
The EnumTransPublications method can only be called by members of the sysadmin fixed server role and members of the db_owner fixed database role.
Calling EnumTransPublications is equivalent to executing sp_helppublication (Transact-SQL).