ReplicationServer.DistributionServer Property

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

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


Public Property DistributionServer As String
Dim instance As ReplicationServer
Dim value As String

value = instance.DistributionServer

instance.DistributionServer = value
public string DistributionServer { get; set; }
property String^ DistributionServer {
    String^ get ();
    void set (String^ value);
member DistributionServer : string with get, set
function get DistributionServer () : String
function set DistributionServer (value : String)

Property Value

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


Exception Condition

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


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.