This topic has not yet been rated - Rate this topic

TransSynchronizationAgent.SubscriptionType Property

SQL Server 2005

Gets or sets whether the subscription is a push or pull subscription.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Replication (in microsoft.sqlserver.replication.dll)

Syntax

C++

public virtual SubscriptionOption SubscriptionType { get; set; }

/** @property */
public SubscriptionOption get_SubscriptionType ()

/** @property */
public void set_SubscriptionType (SubscriptionOption newValue)

JScript

public function get SubscriptionType () : SubscriptionOption

public function set SubscriptionType (newValue : SubscriptionOption)

Property Value

A SubscriptionOption value that indicates the subscription type.

Remarks

The type of subscription you choose depends on where the agent runs. With a push subscription, the Distribution Agent runs at the Distributor; whereas, with a pull subscription, agent runs at the Subscriber. Anonymous subscriptions are required if you want to create a subscription without registering the subscription at the Publisher. This is necessary for cases in which you cannot establish a SQL Server connection to the Publisher during subscription configuration.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

TransSynchronizationAgent.SubscriptionType Property

Property Value

Development Platforms

Target Platforms

Reference

Other Resources

Community Additions