共用方式為


Publication Members

The Publication class is a base class from which the TransPublication class and the MergePublication class are derived.

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

Protected Constructors

  名稱 Description
Publication Creates a new instance of the Publication class.

頂端

Public Properties

  名稱 Description
ms158365.pubproperty(zh-tw,SQL.90).gif AltSnapshotFolder Gets or sets the alternate snapshot file location for a publication.
ms158365.pubproperty(zh-tw,SQL.90).gif Attributes Gets or sets the publication attributes.
ms158365.pubproperty(zh-tw,SQL.90).gif CachePropertyChanges  Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject)
ms158365.pubproperty(zh-tw,SQL.90).gif CompatibilityLevel Gets or sets the earliest version of Microsoft SQL Server running on the Subscribers that the referenced publication can support.
ms158365.pubproperty(zh-tw,SQL.90).gif ConflictRetention Gets or sets the number of days that conflict data rows are retained in conflict tables.
ms158365.pubproperty(zh-tw,SQL.90).gif ConnectionContext  Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158365.pubproperty(zh-tw,SQL.90).gif CreateSnapshotAgentByDefault Gets or sets if the Snapshot Agent job is added automatically when the publication is created.
ms158365.pubproperty(zh-tw,SQL.90).gif DatabaseName Gets or sets the name of the publication database.
ms158365.pubproperty(zh-tw,SQL.90).gif Description Gets or sets a textual description of the publication.
ms158365.pubproperty(zh-tw,SQL.90).gif FtpAddress Gets or sets the address of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
ms158365.pubproperty(zh-tw,SQL.90).gif FtpLogin 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.
ms158365.pubproperty(zh-tw,SQL.90).gif FtpPassword 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.
ms158365.pubproperty(zh-tw,SQL.90).gif FtpPort Gets or sets the port of the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
ms158365.pubproperty(zh-tw,SQL.90).gif FtpSubdirectory Gets or sets the subdirectory on the File Transfer Protocol (FTP) server computer for publications that allow subscription initialization over FTP.
ms158365.pubproperty(zh-tw,SQL.90).gif HasSubscription Gets whether the publication has one or more subscriptions.
ms158365.pubproperty(zh-tw,SQL.90).gif IsExistingObject  Gets whether the object exists on the server or not. (inherited from ReplicationObject)
ms158365.pubproperty(zh-tw,SQL.90).gif Name Gets or sets the name of the publication.
ms158365.pubproperty(zh-tw,SQL.90).gif PostSnapshotScript 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.
ms158365.pubproperty(zh-tw,SQL.90).gif PreSnapshotScript 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.
ms158365.pubproperty(zh-tw,SQL.90).gif PubId Gets the value that uniquely identifies the publication.
ms158365.pubproperty(zh-tw,SQL.90).gif ReplicateDdl Gets or sets the data definition language (DDL) replication options that determine if DDL changes are replicated.
ms158365.pubproperty(zh-tw,SQL.90).gif RetentionPeriod Gets or sets the amount of time before a subscription expires when the subscription is not synchronized with the publication.
ms158365.pubproperty(zh-tw,SQL.90).gif SecureFtpPassword 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.
ms158365.pubproperty(zh-tw,SQL.90).gif SnapshotAgentExists Gets if the SQL Server Agent job exists to generate the initial snapshot for this publication.
ms158365.pubproperty(zh-tw,SQL.90).gif SnapshotGenerationAgentProcessSecurity Gets an object that sets the Windows account under which the Snapshot Agent job runs.
ms158365.pubproperty(zh-tw,SQL.90).gif SnapshotGenerationAgentPublisherSecurity Gets the security context used by the Snapshot Agent to connect to the Publisher.
ms158365.pubproperty(zh-tw,SQL.90).gif SnapshotJobId Gets the Snapshot Agent job ID for the current publication.
ms158365.pubproperty(zh-tw,SQL.90).gif SnapshotMethod Gets or sets the data file format of the initial snapshot.
ms158365.pubproperty(zh-tw,SQL.90).gif SnapshotSchedule Gets an object that sets the schedule for the Snapshot Agent for the current publication.
ms158365.pubproperty(zh-tw,SQL.90).gif SqlServerName  Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject)
ms158365.pubproperty(zh-tw,SQL.90).gif Status Gets or sets the status of the publication.
ms158365.pubproperty(zh-tw,SQL.90).gif Type Gets or sets the type of publication.
ms158365.pubproperty(zh-tw,SQL.90).gif UserData  Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject)

頂端

Public Methods

(see also Protected Methods )

  名稱 Description
ms158365.pubmethod(zh-tw,SQL.90).gif CommitPropertyChanges  Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158365.pubmethod(zh-tw,SQL.90).gif Create Creates the publication.
ms158365.pubmethod(zh-tw,SQL.90).gif CreateSnapshotAgent Creates the SQL Server Agent job that is used to generate the initial snapshot for the publication, if this job does not already exist.
ms158365.pubmethod(zh-tw,SQL.90).gif Decouple  Decouples the referenced replication object from the server. (inherited from ReplicationObject)
ms158365.pubmethod(zh-tw,SQL.90).gif EnumArticles Returns the articles in the publication.
ms158365.pubmethod(zh-tw,SQL.90).gif EnumPublicationAccesses Returns logins that have access to the Publisher.
ms158365.pubmethod(zh-tw,SQL.90).gif EnumSubscriptions Returns the subscriptions that subscribe to the publication.
ms158365.pubmethod(zh-tw,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms158365.pubmethod(zh-tw,SQL.90).gif GetHashCode  (inherited from Object )
ms158365.pubmethod(zh-tw,SQL.90).gif GetType  (inherited from Object )
ms158365.pubmethod(zh-tw,SQL.90).gif GrantPublicationAccess Adds the specified login to the publication access list (PAL).
ms158365.pubmethod(zh-tw,SQL.90).gif Load  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158365.pubmethod(zh-tw,SQL.90).gif LoadProperties  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158365.pubmethod(zh-tw,SQL.90).gifms158365.static(zh-tw,SQL.90).gif ReferenceEquals  (inherited from Object )
ms158365.pubmethod(zh-tw,SQL.90).gif Refresh  Reloads the properties of the object. (inherited from ReplicationObject)
ms158365.pubmethod(zh-tw,SQL.90).gif Remove Overloaded. Removes an existing publication.
ms158365.pubmethod(zh-tw,SQL.90).gif ReplicateUserDefinedScript Replicates the execution of a user-defined script to the Subscribers of a specified publication.
ms158365.pubmethod(zh-tw,SQL.90).gif RevokePublicationAccess Removes the specified login from the publication access list (PAL).
ms158365.pubmethod(zh-tw,SQL.90).gif Script Generates a Transact-SQL script that can be used to re-create the publication as specified by the script options.
ms158365.pubmethod(zh-tw,SQL.90).gif StartSnapshotGenerationAgentJob Starts the job that generates the initial snapshot for the publication.
ms158365.pubmethod(zh-tw,SQL.90).gif StopSnapshotGenerationAgentJob Attempts to stop a running Snapshot Agent job.
ms158365.pubmethod(zh-tw,SQL.90).gif ToString  (inherited from Object )

頂端

Protected Methods

  名稱 Description
ms158365.protmethod(zh-tw,SQL.90).gif CheckValidCreation  (inherited from ReplicationObject )
ms158365.protmethod(zh-tw,SQL.90).gif CheckValidDefinition Overridden.  
ms158365.protmethod(zh-tw,SQL.90).gif Finalize  (inherited from Object )
ms158365.protmethod(zh-tw,SQL.90).gif GetChangeCommand  (inherited from ReplicationObject )
ms158365.protmethod(zh-tw,SQL.90).gif GetCreateCommand  (inherited from ReplicationObject )
ms158365.protmethod(zh-tw,SQL.90).gif GetDropCommand  (inherited from ReplicationObject )
ms158365.protmethod(zh-tw,SQL.90).gif InternalRefresh  (inherited from ReplicationObject )
ms158365.protmethod(zh-tw,SQL.90).gif MemberwiseClone  (inherited from Object )

頂端

請參閱

參考

Publication Class
Microsoft.SqlServer.Replication Namespace