Subscription Properties

 

Namespace:   Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

NameDescription
System_CAPS_pubpropertyAgentJobId

Gets the ID of the agent job used to synchronize the subscription.

System_CAPS_pubpropertyAgentOffload

Gets or sets whether the synchronization agent runs on a computer other than the one where the agent job was created. This property is no longer supported for Distributors running Microsoft SQL Server 2005 and later.

System_CAPS_pubpropertyAgentOffloadServer

Gets or sets the name of the remote computer where the agent runs when using remote agent activation.

System_CAPS_pubpropertyAgentSchedule

Gets the schedule for the agent job used to synchronize the subscription.

System_CAPS_pubpropertyCachePropertyChanges

Gets or sets whether to cache changes made to the replication properties or to apply them immediately.(Inherited from ReplicationObject.)

System_CAPS_pubpropertyConnectionContext

Gets or sets the connection to an instance of Microsoft SQL Server.(Inherited from ReplicationObject.)

System_CAPS_pubpropertyCreateSyncAgentByDefault

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

System_CAPS_pubpropertyDatabaseName

Gets or sets the name of the publication database.

System_CAPS_pubpropertyEnabledForSynchronizationManager

Specifies whether the subscription can be synchronized using Microsoft Windows Synchronization Manager.

System_CAPS_pubpropertyIsExistingObject

Gets whether the object exists on the server or not.(Inherited from ReplicationObject.)

System_CAPS_pubpropertyName

Gets the name assigned to an existing subscription.

System_CAPS_pubpropertyPublicationName

Gets or sets the name of the publication to which the subscription subscribes.

System_CAPS_pubpropertySqlServerName

Gets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)

System_CAPS_pubpropertyStatus

Gets the status of the subscription.

System_CAPS_pubpropertySubscriberName

Gets or sets the name of the instance of Microsoft SQL Server that is the Subscriber.

System_CAPS_pubpropertySubscriberSecurity

Gets the security context used to connect to the Subscriber.

System_CAPS_pubpropertySubscriptionDBName

Gets or sets the name of the database on the Subscriber that receives the replicated data.

System_CAPS_pubpropertySubscriptionType

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

System_CAPS_pubpropertySynchronizationAgentName

Gets or sets the name of the agent job created to synchronize the subscription.

System_CAPS_pubpropertySynchronizationAgentProcessSecurity

Gets the security context that is used to specify the Microsoft Windows account under which the synchronization agent job runs to synchronize the subscription.

System_CAPS_pubpropertySyncType

Gets or sets the manner in which the subscription is initialized.

System_CAPS_pubpropertyUserData

Gets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)

Return to top
Show: