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 SubscriptionOption SubscriptionType { get; }

속성 값

유형: 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 Programming).

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.

커뮤니티 추가 항목