Partilhar via

  • Artigo

Propriedade DistributionServer

Gets or sets the name of the Distributor for the currently connected instance of SQL Server.

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

Sintaxe

'Declaração
Public Property DistributionServer As String
    Get
    Set
'Uso
Dim instance As ReplicationServer
Dim value As String

value = instance.DistributionServer

instance.DistributionServer = value

public string DistributionServer { get; set; }

public:
property String^ DistributionServer {
    String^ get ();
    void set (String^ value);
}

member DistributionServer : string with get, set

function get DistributionServer () : String
function set DistributionServer (value : String)

Valor da propriedade

Tipo: System. . :: . .String
A String value that specifies the instance of SQL Server that is the Distributor.

Exceções

Exceção Condição
ArgumentException

When the string is null, is improperly formatted, or exceeds 128 bytes.

Comentários

The DistributionServer property is equivalent to the sp_get_distributor (Transact-SQL) stored procedure.

The DistributionServer property can be retrieved by the public fixed database role.

The DistributionServer property can be set only by the sysadmin fixed server role.

This property is available with SQL Server 7.0, SQL Server 2000, and SQL Server 2005.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.