Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Status Property

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

© 2015 Microsoft