Export (0) Print
Expand All

Subscription.Status Property

Gets the status of the subscription.

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

public SubscriptionState Status { get; }

Property Value

Type: Microsoft.SqlServer.Replication.SubscriptionState
A SubscriptionState object specifies the status of the subscription.

The Status property is a read-only property.

The Status property can only be retrieved by members of the sysadmin fixed server role at the Publisher, by members of the db_owner fixed database role on the publication database, or by the user that created the subscription.

Retrieving the Status property is equivalent to executing sp_helpsubscription or sp_helpmergesubscription.

Community Additions

© 2014 Microsoft