共用方式為


Subscription.SubscriptionType 屬性

Gets whether the subscription registration is for a push or pull subscription.

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

語法

'宣告
Public ReadOnly Property SubscriptionType As SubscriptionOption 
    Get
'用途
Dim instance As Subscription 
Dim value As SubscriptionOption 

value = instance.SubscriptionType
public SubscriptionOption SubscriptionType { get; }
public:
property SubscriptionOption SubscriptionType {
    SubscriptionOption get ();
}
member SubscriptionType : SubscriptionOption
function get SubscriptionType () : SubscriptionOption

屬性值

型別:Microsoft.SqlServer.Replication.SubscriptionOption
A SubscriptionOption value. If Push, the subscription is a push subscription.

備註

The SubscriptionType property is a read-only property.

In Microsoft SQL Server 2005, all subscriptions are tracked at the Publisher. Anonymous is never returned.

Use TransPullSubscription or MergePullSubscription to create a pull subscription. For more information, see 如何:建立提取訂閱 (RMO 程式設計).

The SubscriptionType 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 SubscriptionType property is equivalent to executing sp_helpsubscription or sp_helpmergesubscription.

請參閱

參考

Subscription 類別

Microsoft.SqlServer.Replication 命名空間