Distributor 屬性

Gets or sets the name of the instance of SQL Server acting as the Distributor for the publication.

命名空間：  Microsoft.SqlServer.Replication
組件：  Microsoft.SqlServer.Replication (在 Microsoft.SqlServer.Replication.dll 中)

語法

'宣告
Public Property Distributor As String
    Get
    Set
'用途
Dim instance As SnapshotGenerationAgent
Dim value As String

value = instance.Distributor

instance.Distributor = value

public string Distributor { get; set; }

public:
virtual property String^ Distributor {
    String^ get () sealed;
    void set (String^ value) sealed;
}

abstract Distributor : string with get, set
override Distributor : string with get, set

final function get Distributor () : String
final function set Distributor (value : String)

屬性值

型別：System. . :: . .String
A String value that is the name of the Distributor.

實作

ISnapshotGenerationAgent. . :: . .Distributor

備註

Distributor is a required property. If this property is not specified, a ReplicationAgentException

is thrown.

The Distributor is the instance of Microsoft SQL Server on which the snapshots for the publication are stored.

範例

         // Set the Publisher, publication database, and publication names.
            string publicationName = "AdvWorksProductTran";
            string publicationDbName = "AdventureWorks2008R2";
            string publisherName = publisherInstance;
            string distributorName = publisherInstance;

            SnapshotGenerationAgent agent;

            try
            {
                // Set the required properties for Snapshot Agent.
                agent = new SnapshotGenerationAgent();
                agent.Distributor = distributorName;
                agent.DistributorSecurityMode = SecurityMode.Integrated;
                agent.Publisher = publisherName;
                agent.PublisherSecurityMode = SecurityMode.Integrated;
                agent.Publication = publicationName;
                agent.PublisherDatabase = publicationDbName;
                agent.ReplicationType = ReplicationType.Transactional;

                // Start the agent synchronously.
                agent.GenerateSnapshot();

            }
            catch (Exception ex)
            {
                // Implement custom application error handling here.
                throw new ApplicationException(String.Format(
                    "A snapshot could not be generated for the {0} publication."
                    , publicationName), ex);
            }

' Set the Publisher, publication database, and publication names.
Dim publicationName As String = "AdvWorksProductTran"
Dim publicationDbName As String = "AdventureWorks2008R2"
Dim publisherName As String = publisherInstance
Dim distributorName As String = publisherInstance

Dim agent As SnapshotGenerationAgent

Try
    ' Set the required properties for Snapshot Agent.
    agent = New SnapshotGenerationAgent()
    agent.Distributor = distributorName
    agent.DistributorSecurityMode = SecurityMode.Integrated
    agent.Publisher = publisherName
    agent.PublisherSecurityMode = SecurityMode.Integrated
    agent.Publication = publicationName
    agent.PublisherDatabase = publicationDbName
    agent.ReplicationType = ReplicationType.Transactional

    ' Start the agent synchronously.
    agent.GenerateSnapshot()

Catch ex As Exception
    ' Implement custom application error handling here.
    Throw New ApplicationException(String.Format( _
     "A snapshot could not be generated for the {0} publication." _
     , publicationName), ex)
End Try

請參閱

參考

SnapshotGenerationAgent 類別

Microsoft.SqlServer.Replication 命名空間