TransSubscription Members

  • Article

Represents a push subscription to a transactional or snapshot publication.

The following tables list the members exposed by the TransSubscription type.

Public Constructors

  Name Description
TransSubscription Overloaded. Creates a new instance of the TransSubscription class.

Top

Public Properties

  Name Description
ms158399.pubproperty(en-US,SQL.90).gif AgentJobId  Gets the ID of the agent job used to synchronize the subscription. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif AgentOffload  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. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif AgentOffloadServer  Gets or sets the name of the remote computer where the agent runs when using remote agent activation. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif AgentSchedule  Gets the schedule for the agent job used to synchronize the subscription. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif BackupInformation Gets or sets information needed to initialize a subscription from a backup.
ms158399.pubproperty(en-US,SQL.90).gif CachePropertyChanges  Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject)
ms158399.pubproperty(en-US,SQL.90).gif ConnectionContext  Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158399.pubproperty(en-US,SQL.90).gif CreateSyncAgentByDefault  Gets or sets whether the agent job used to synchronize the subscription is created by default. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif DatabaseName  Gets or sets the name of the publication database. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif DtsPackageLocation Gets or sets the location of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package.
ms158399.pubproperty(en-US,SQL.90).gif DtsPackageName Gets or sets the name of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package that is applied at the Subscriber.
ms158399.pubproperty(en-US,SQL.90).gif DtsPackagePassword Sets the password used to run the Microsoft SQL Server 2000 Data Transformation Services (DTS) package.
ms158399.pubproperty(en-US,SQL.90).gif EnabledForSynchronizationManager  Specifies whether the subscription can be synchronized using Microsoft Windows Synchronization Manager. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif FullSubscription  
ms158399.pubproperty(en-US,SQL.90).gif IsExistingObject  Gets whether the object exists on the server or not. (inherited from ReplicationObject)
ms158399.pubproperty(en-US,SQL.90).gif LoopBackDetection Gets or sets whether or not the Distribution Agent sends transactions that originated at the Subscriber back to the Subscriber.
ms158399.pubproperty(en-US,SQL.90).gif Name  Gets the name assigned to an existing subscription. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif PublicationName  Gets or sets the name of the publication to which the subscription subscribes. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif PublisherName Gets or sets the name of the Publisher when the subscription belongs to a non- SQL Server Publisher.
ms158399.pubproperty(en-US,SQL.90).gif SecureDtsPackagePassword Sets the password (as a SecureString object) used to run the Microsoft SQL Server 2000 Data Transformation Services (DTS) package.
ms158399.pubproperty(en-US,SQL.90).gif SqlServerName  Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject)
ms158399.pubproperty(en-US,SQL.90).gif Status  Gets the status of the subscription. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif SubscriberCatalog Gets or sets the catalog used when making a connection to the OLE DB provider for a non-SQL Server Subscriber.
ms158399.pubproperty(en-US,SQL.90).gif SubscriberDatasource Name of the data source as understood by the OLE DB provider for a non-SQL Server Subscriber.
ms158399.pubproperty(en-US,SQL.90).gif SubscriberDatasourceType Identifies the type of data source that is a non-SQL Server Subscriber.
ms158399.pubproperty(en-US,SQL.90).gif SubscriberLocation Location of the database as understood by the OLE DB provider for the non-SQL Server Subscriber.
ms158399.pubproperty(en-US,SQL.90).gif SubscriberName  Gets or sets the name of the instance of Microsoft SQL Server that is the Subscriber. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif SubscriberProvider Unique programmatic identifier (PROGID) with which the OLE DB provider for the non-SQL Server Subscriber is registered
ms158399.pubproperty(en-US,SQL.90).gif SubscriberProviderString OLE DB provider-specific connection string is used to connect to the data source for non-SQL Server Subscribers.
ms158399.pubproperty(en-US,SQL.90).gif SubscriberSecurity  Gets the security context used to connect to the Subscriber. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif SubscriberType Gets or sets the updating behavior for data changes at the Subscriber.
ms158399.pubproperty(en-US,SQL.90).gif SubscriptionDBName  Gets or sets the name of the database on the Subscriber that receives the replicated data. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif SubscriptionType  Gets whether the subscription registration is for a push or pull subscription. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif SynchronizationAgent Gets an instance of the TransSynchronizationAgent class that can be used to synchronize the subscription.
ms158399.pubproperty(en-US,SQL.90).gif SynchronizationAgentName  Gets or sets the name of the agent job created to synchronize the subscription. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif SynchronizationAgentProcessSecurity  Gets the security context that is used to specify the Microsoft Windows account under which the synchronization agent job runs to synchronize the subscription. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif SyncType  Gets or sets the manner in which the subscription is initialized. (inherited from Subscription)
ms158399.pubproperty(en-US,SQL.90).gif UserData  Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms158399.pubmethod(en-US,SQL.90).gif CommitPropertyChanges  Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158399.pubmethod(en-US,SQL.90).gif Create  Creates the subscription registration at the Publisher. (inherited from Subscription)
ms158399.pubmethod(en-US,SQL.90).gif Decouple  Decouples the referenced replication object from the server. (inherited from ReplicationObject)
ms158399.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms158399.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms158399.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms158399.pubmethod(en-US,SQL.90).gif Load  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158399.pubmethod(en-US,SQL.90).gif LoadProperties  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158399.pubmethod(en-US,SQL.90).gifms158399.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms158399.pubmethod(en-US,SQL.90).gif Refresh  Reloads the properties of the object. (inherited from ReplicationObject)
ms158399.pubmethod(en-US,SQL.90).gif Reinitialize Overloaded.  
ms158399.pubmethod(en-US,SQL.90).gif Remove  Deletes the subscription registration at the Publisher and removes replication objects at the Subscriber for a push subscription. (inherited from Subscription)
ms158399.pubmethod(en-US,SQL.90).gif Script  (inherited from Subscription )
ms158399.pubmethod(en-US,SQL.90).gif StopSynchronizationJob Attempts to stop a running Distribution Agent job that is currently synchronizing the subscription.
ms158399.pubmethod(en-US,SQL.90).gif SynchronizeWithJob Starts the agent job to synchronize the subscription.
ms158399.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms158399.protmethod(en-US,SQL.90).gif CheckValidCreation  (inherited from ReplicationObject )
ms158399.protmethod(en-US,SQL.90).gif CheckValidDefinition  (inherited from Subscription )
ms158399.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms158399.protmethod(en-US,SQL.90).gif GetChangeCommand  (inherited from ReplicationObject )
ms158399.protmethod(en-US,SQL.90).gif GetCreateCommand  (inherited from ReplicationObject )
ms158399.protmethod(en-US,SQL.90).gif GetDropCommand  (inherited from ReplicationObject )
ms158399.protmethod(en-US,SQL.90).gif InternalRefresh  (inherited from ReplicationObject )
ms158399.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

TransSubscription Class
Microsoft.SqlServer.Replication Namespace

Other Resources

How to: Create a Push Subscription (RMO Programming)