Publication Properties

 

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

NameDescription
System_CAPS_pubpropertyAltSnapshotFolder

Gets or sets the alternate snapshot file location for a publication.

System_CAPS_pubpropertyAttributes

Gets or sets the publication attributes.

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_pubpropertyCompatibilityLevel

Gets or sets the earliest version of Microsoft SQL Server running on the Subscribers that the referenced publication can support.

System_CAPS_pubpropertyConflictRetention

Gets or sets the number of days that conflict data rows are retained in conflict tables.

System_CAPS_pubpropertyConnectionContext

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

System_CAPS_pubpropertyCreateSnapshotAgentByDefault

Gets or sets if the Snapshot Agent job is added automatically when the publication is created.

System_CAPS_pubpropertyDatabaseName

Gets or sets the name of the publication database.

System_CAPS_pubpropertyDescription

Gets or sets a textual description of the publication.

System_CAPS_pubpropertyFtpAddress

Gets or sets the address of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.

System_CAPS_pubpropertyFtpLogin

Gets or sets the login that is used to connect to the File Transfer Protocol (FTP) server for publications that allow subscription initialization over FTP.

System_CAPS_pubpropertyFtpPassword

Sets the password for the login that is used to connect to the File Transfer Protocol (FTP) server for publications that allow subscription initialization over FTP.

System_CAPS_pubpropertyFtpPort

Gets or sets the port of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.

System_CAPS_pubpropertyFtpSubdirectory

Gets or sets the subdirectory on the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.

System_CAPS_pubpropertyHasSubscription

Gets whether the publication has one or more subscriptions.

System_CAPS_pubpropertyIsExistingObject

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

System_CAPS_pubpropertyName

Gets or sets the name of the publication.

System_CAPS_pubpropertyPostSnapshotScript

Gets or sets the name and full path of a Transact-SQL script file that is executed after the initial snapshot is applied to the Subscriber.

System_CAPS_pubpropertyPreSnapshotScript

Gets or sets the name and full path of a Transact-SQL script file that is executed before the initial snapshot is applied to the Subscriber.

System_CAPS_pubpropertyPubId

Gets the value that uniquely identifies the publication.

System_CAPS_pubpropertyReplicateDdl

Gets or sets the data definition language (DDL) replication options that determine if DDL changes are replicated.

System_CAPS_pubpropertyRetentionPeriod

Gets or sets the amount of time before a subscription expires when the subscription is not synchronized with the publication.

System_CAPS_pubpropertySecureFtpPassword

Sets the password (as a SecureString object) for the login used to connect to the File Transfer Protocol (FTP) server for publications that allow subscription initialization over FTP.

System_CAPS_pubpropertySnapshotAgentExists

Gets if the SQL Server Agent job exists to generate the initial snapshot for this publication.

System_CAPS_pubpropertySnapshotGenerationAgentProcessSecurity

Gets an object that sets the Windows account under which the Snapshot Agent job runs.

System_CAPS_pubpropertySnapshotGenerationAgentPublisherSecurity

Gets the security context used by the Snapshot Agent to connect to the Publisher.

System_CAPS_pubpropertySnapshotJobId

Gets the Snapshot Agent job ID for the current publication.

System_CAPS_pubpropertySnapshotMethod

Gets or sets the data file format of the initial snapshot.

System_CAPS_pubpropertySnapshotSchedule

Gets an object that sets the schedule for the Snapshot Agent for the current publication.

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 or sets the status of the publication.

System_CAPS_pubpropertyType

Gets or sets the type of publication.

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: