ReplicationServer.EnumSubscriberSubscriptions Method

Returns the subscriptions on a Subscriber server.

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

Syntax

'Declaration
Public Function EnumSubscriberSubscriptions ( _
    databaseName As String, _
    subscriptionType As Integer _
) As ArrayList
'Usage
Dim instance As ReplicationServer 
Dim databaseName As String 
Dim subscriptionType As Integer 
Dim returnValue As ArrayList 

returnValue = instance.EnumSubscriberSubscriptions(databaseName, _
    subscriptionType)
public ArrayList EnumSubscriberSubscriptions(
    string databaseName,
    int subscriptionType
)
public:
ArrayList^ EnumSubscriberSubscriptions(
    String^ databaseName, 
    int subscriptionType
)
member EnumSubscriberSubscriptions : 
        databaseName:string * 
        subscriptionType:int -> ArrayList
public function EnumSubscriberSubscriptions(
    databaseName : String, 
    subscriptionType : int
) : ArrayList

Parameters

  • databaseName
    Type: System.String
    A String value that specifies the database name from which the subscriptions are enumerated. Use a nulla null reference (Nothing in Visual Basic) value to enumerate subscriptions in all databases on the Subscriber.
  • subscriptionType
    Type: System.Int32
    An integer value that specifies the subscription type for the returned subscription:Push Pull and anonymous Both

Return Value

Type: System.Collections.ArrayList
An ArrayList of SubscriberSubscription objects.

Remarks

The structure holds limited information about the subscription.

The EnumSubscriberSubscriptions method can only be called by members of the db_owner fixed database role on the subscription database.

See Also

Reference

ReplicationServer Class

Microsoft.SqlServer.Replication Namespace