Subscription.Status Property
Gets the status of the subscription.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public ReadOnly Property Status As SubscriptionState
Get
'Usage
Dim instance As Subscription
Dim value As SubscriptionState
value = instance.Status
public SubscriptionState Status { get; }
public:
property SubscriptionState Status {
SubscriptionState get ();
}
member Status : SubscriptionState
function get Status () : SubscriptionState
Property Value
Type: Microsoft.SqlServer.Replication.SubscriptionState
A SubscriptionState object specifies the status of the subscription.
Remarks
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.