共用方式為


Subscription.Status 屬性

Gets the status of the subscription.

命名空間:  Microsoft.SqlServer.Replication
組件:  Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
Public ReadOnly Property Status As SubscriptionState 
    Get
'用途
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

屬性值

型別: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.

請參閱

參考

Subscription 類別

Microsoft.SqlServer.Replication 命名空間