Aracılığıyla paylaş


Subscription.Status Property

Definition

Gets the status of the subscription.

public:
 property Microsoft::SqlServer::Replication::SubscriptionState Status { Microsoft::SqlServer::Replication::SubscriptionState get(); };
public Microsoft.SqlServer.Replication.SubscriptionState Status { get; }
member this.Status : Microsoft.SqlServer.Replication.SubscriptionState
Public ReadOnly Property Status As SubscriptionState

Property Value

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.

Applies to