ReplicationServer.DistributionDatabase Property
Gets the name of the distribution database for the currently connected instance of SQL Server.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public ReadOnly Property DistributionDatabase As String
Get
'Usage
Dim instance As ReplicationServer
Dim value As String
value = instance.DistributionDatabase
public string DistributionDatabase { get; }
public:
property String^ DistributionDatabase {
String^ get ();
}
member DistributionDatabase : string
function get DistributionDatabase () : String
Property Value
Type: System.String
A String value that specifies the name of the distribution database.
Remarks
The DistributionDatabase property is only valid when the current server is a Publisher. A value of true for the IsPublisher property indicates that the server is a Publisher.
The DistributionDatabase property can only be set by a member of the sysadmin fixed server role.
The DistributionDatabase property can only be retrieved by a member of the sysadmin fixed server role at the Distributor or a member of the db_owner fixed database role in the distribution database.
See Also
Reference
Microsoft.SqlServer.Replication Namespace