Subscription.CreateSyncAgentByDefault Property

Gets or sets whether the agent job used to synchronize the subscription is created by default.

Spazio dei nomi: Microsoft.SqlServer.Replication
Assembly : Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Sintassi

'Dichiarazione
Public Property CreateSyncAgentByDefault As Boolean

public bool CreateSyncAgentByDefault { get; set; }

public:
property bool CreateSyncAgentByDefault {
    bool get ();
    void set (bool value);
}

/** @property */
public boolean get_CreateSyncAgentByDefault ()

/** @property */
public void set_CreateSyncAgentByDefault (boolean value)

public function get CreateSyncAgentByDefault () : boolean

public function set CreateSyncAgentByDefault (value : boolean)

Valore proprietà

A Boolean value. If true, the agent job is created. If false, the agent job is not created.

Osservazioni

The CreateSyncAgentByDefault property is only used when a new subscription is created.

The default value for CreateSyncAgentByDefault is true.

When an agent job is created, metadata required by Microsoft SQL Server Agent to synchronize the subscription is stored in the MSsubscription_properties table. When you create a subscription and specify a value of false for CreateSyncAgentByDefault, a data row is not added to the MSsubscription_properties table for the subscription. In this case, many of the properties of the MergeSubscription or TransSubscription object that represent a subscription cannot be saved on the server. To persist any of the subscription properties in the MSsubscription_properties table, you must specify a value of true for CreateSyncAgentByDefault.

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.

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

Subscription Class
Subscription Members
Microsoft.SqlServer.Replication Namespace
MergeSubscription.SynchronizationAgent Property
SynchronizationAgent