Export (0) Print
Expand All

TransSynchronizationAgent Properties

Topic Status: Some information in this topic is pre-release and subject to change in future releases. Pre-release information describes new features or changes to existing features in Microsoft SQL Server 2014.

The TransSynchronizationAgent type exposes the following members.

  Name Description
Public property AltSnapshotFolder Gets or sets the alternate snapshot folder for the subscription.
Public property ComErrorCollection Gets a collection of errors that are generated by the replication agent.
Public property Distributor Gets or sets the name of the instance of Microsoft SQL Server that is acting as the distributor for the subscription.
Public property DistributorAddress Gets or sets the network address that is used to connect to the distributor when the DistributorNetwork property is specified.
Public property DistributorEncryptedPassword Infrastructure. Gets or sets the encrypted password that is used when connecting to the distributor by using SQL Server Authentication.
Public property DistributorLogin Gets or sets the login name that is used when connecting to the distributor by using SQL Server Authentication.
Public property DistributorNetwork Gets or sets the client Net-Library that is used when connecting to the distributor.
Public property DistributorPassword Gets or sets the password that is used when connecting to the Distributor by using SQL Server Authentication.
Public property DistributorSecurityMode Gets or sets the security mode that is used when connecting to the distributor.
Public property DtsPackageFileName Gets or sets the name and path of a Microsoft SQL Server 2000 Data Transformation Services (DTS) package that is used to transform command rowsets before they are applied to a Subscriber.
Public property DtsPackagePassword Gets or sets the owner password that used to access the Microsoft SQL Server 2000 Data Transformation Services (DTS) package specified by the DtsPackageFileName property.
Public property FileTransferType Gets or sets how the initial snapshot files are transferred to the Subscriber.
Public property HostName Infrastructure. Gets or sets the host name used.
Public property LastUpdatedTime Gets the timestamp of the last time that replication agent synchronized the subscription.
Public property LoginTimeout Gets or sets the maximum number of seconds to wait for connections to be established.
Public property MaxDeliveredTransactions Gets or sets the maximum number of transactions that are applied to the Subscriber during a single agent execution.
Public property Output Gets or sets the file name and path of the agent output file.
Public property OutputVerboseLevel Gets or sets the amount of information that is logged by the Distribution Agent in the agent output file.
Public property ProfileName Gets or sets the name of the profile that is used by the agent.
Public property Publication Gets or sets the name of the publication.
Public property Publisher Gets or sets the name of the instance of Microsoft SQL Server that is the Publisher for the subscription.
Public property PublisherDatabase Gets or sets the name of the publication database.
Public property QueryTimeout Gets or sets the number of seconds that are allowed for internal queries to complete.
Public property SecureDistributorEncryptedPassword Infrastructure. Gets or sets the secure encrypted password for the distributor.
Public property SecureSubscriberEncryptedPassword Infrastructure. Gets or sets the secure encrypted password for the subscriber.
Public property SkipErrors Gets or sets a colon-separated list of the error numbers that are to be skipped by this agent.
Public property Subscriber Gets or sets the name of the instance of Microsoft SQL Server that is the subscriber.
Public property SubscriberDatabase Gets or sets the name of the subscription database.
Public property SubscriberDatabasePath Infrastructure. Get or sets the database path for the subscriber.
Public property SubscriberDataSourceType Gets or sets the type of data source that is used as the subscriber.
Public property SubscriberEncryptedPassword Infrastructure. Gets or sets the encrypted password for the subscriber.
Public property SubscriberLogin Gets or sets the login name that is used when connecting to the subscriber by using SQL Server Authentication.
Public property SubscriberPassword Gets or sets the password that is used when connecting to the subscriber by using SQL Server Authentication.
Public property SubscriberSecurityMode Gets or sets the security mode that is used when connecting to the publisher.
Public property SubscriptionType Gets or sets whether the subscription is a push or pull subscription.
Public property UndeliveredCommands Infrastructure. Gets the number of undelivered commands.
Public property UndeliveredTransactions Infrastructure. Gets the number of undelivered transactions.
Public property UseInProcLoader Gets or sets a value that indicates whether to use the BULK INSERT command when applying snapshot files at the subscriber.
Public property WorkingDirectory Gets or sets the working directory from which snapshot files are accessed when File Transfer Protocol (FTP) is used.
Top

Community Additions

Show:
© 2014 Microsoft