TransSubscription Members
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 | |
|---|---|---|
.gif "ms158399.pubproperty(en-US,SQL.90).gif") |
AgentJobId | Gets the ID of the agent job used to synchronize the subscription. (inherited from Subscription) |
|
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) |
|
AgentOffloadServer | Gets or sets the name of the remote computer where the agent runs when using remote agent activation. (inherited from Subscription) |
|
AgentSchedule | Gets the schedule for the agent job used to synchronize the subscription. (inherited from Subscription) |
|
BackupInformation | Gets or sets information needed to initialize a subscription from a backup. |
|
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject) |
|
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject) |
|
CreateSyncAgentByDefault | Gets or sets whether the agent job used to synchronize the subscription is created by default. (inherited from Subscription) |
|
DatabaseName | Gets or sets the name of the publication database. (inherited from Subscription) |
|
DtsPackageLocation | Gets or sets the location of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package. |
|
DtsPackageName | Gets or sets the name of the Microsoft SQL Server 2000 Data Transformation Services (DTS) package that is applied at the Subscriber. |
|
DtsPackagePassword | Sets the password used to run the Microsoft SQL Server 2000 Data Transformation Services (DTS) package. |
|
EnabledForSynchronizationManager | Specifies whether the subscription can be synchronized using Microsoft Windows Synchronization Manager. (inherited from Subscription) |
|
FullSubscription | |
|
IsExistingObject | Gets whether the object exists on the server or not. (inherited from ReplicationObject) |
|
LoopBackDetection | Gets or sets whether or not the Distribution Agent sends transactions that originated at the Subscriber back to the Subscriber. |
|
Name | Gets the name assigned to an existing subscription. (inherited from Subscription) |
|
PublicationName | Gets or sets the name of the publication to which the subscription subscribes. (inherited from Subscription) |
|
PublisherName | Gets or sets the name of the Publisher when the subscription belongs to a non- SQL Server Publisher. |
|
SecureDtsPackagePassword | Sets the password (as a SecureString object) used to run the Microsoft SQL Server 2000 Data Transformation Services (DTS) package. |
|
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject) |
|
Status | Gets the status of the subscription. (inherited from Subscription) |
|
SubscriberCatalog | Gets or sets the catalog used when making a connection to the OLE DB provider for a non-SQL Server Subscriber. |
|
SubscriberDatasource | Name of the data source as understood by the OLE DB provider for a non-SQL Server Subscriber. |
|
SubscriberDatasourceType | Identifies the type of data source that is a non-SQL Server Subscriber. |
|
SubscriberLocation | Location of the database as understood by the OLE DB provider for the non-SQL Server Subscriber. |
|
SubscriberName | Gets or sets the name of the instance of Microsoft SQL Server that is the Subscriber. (inherited from Subscription) |
|
SubscriberProvider | Unique programmatic identifier (PROGID) with which the OLE DB provider for the non-SQL Server Subscriber is registered |
|
SubscriberProviderString | OLE DB provider-specific connection string is used to connect to the data source for non-SQL Server Subscribers. |
|
SubscriberSecurity | Gets the security context used to connect to the Subscriber. (inherited from Subscription) |
|
SubscriberType | Gets or sets the updating behavior for data changes at the Subscriber. |
|
SubscriptionDBName | Gets or sets the name of the database on the Subscriber that receives the replicated data. (inherited from Subscription) |
|
SubscriptionType | Gets whether the subscription registration is for a push or pull subscription. (inherited from Subscription) |
|
SynchronizationAgent | Gets an instance of the TransSynchronizationAgent class that can be used to synchronize the subscription. |
|
SynchronizationAgentName | Gets or sets the name of the agent job created to synchronize the subscription. (inherited from Subscription) |
|
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) |
|
SyncType | Gets or sets the manner in which the subscription is initialized. (inherited from Subscription) |
|
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 | |
|---|---|---|
.gif "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) |
|
Create | Creates the subscription registration at the Publisher. (inherited from Subscription) |
|
Decouple | Decouples the referenced replication object from the server. (inherited from ReplicationObject) |
|
Equals | Overloaded. (inherited from Object ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
|
Load | Loads the properties of an existing object from the server. (inherited from ReplicationObject) |
|
LoadProperties | Loads the properties of an existing object from the server. (inherited from ReplicationObject) |
.gif "ms158399.static(en-US,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
Refresh | Reloads the properties of the object. (inherited from ReplicationObject) |
|
Reinitialize | Overloaded. |
|
Remove | Deletes the subscription registration at the Publisher and removes replication objects at the Subscriber for a push subscription. (inherited from Subscription) |
|
Script | (inherited from Subscription ) |
|
StopSynchronizationJob | Attempts to stop a running Distribution Agent job that is currently synchronizing the subscription. |
|
SynchronizeWithJob | Starts the agent job to synchronize the subscription. |
|
ToString | (inherited from Object ) |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms158399.protmethod(en-US,SQL.90).gif") |
CheckValidCreation | (inherited from ReplicationObject ) |
|
CheckValidDefinition | (inherited from Subscription ) |
|
Finalize | (inherited from Object ) |
|
GetChangeCommand | (inherited from ReplicationObject ) |
|
GetCreateCommand | (inherited from ReplicationObject ) |
|
GetDropCommand | (inherited from ReplicationObject ) |
|
InternalRefresh | (inherited from ReplicationObject ) |
|
MemberwiseClone | (inherited from Object ) |
Top
See Also
Reference
TransSubscription Class
Microsoft.SqlServer.Replication Namespace