The DistributionServer property identifies the Microsoft® SQL Server™ installation that is acting as a Distributor for published data.
object.DistributionServer [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Name of a SQL Server installation in the organization. |
For SQL Server, replication Publishers do not need to also distribute published data. One or more SQL Server installations may act as Distributors. If the Publisher is not its own Distributor, the DistributionServer identifies that server.
For SQL Server installations acting as their own Distributors, the DistributionServer property is equal to the Name property of the SQLServer object.
String
Read/write
HRESULT GetDistributionServer(SQLDMO_LPBSTR pRetVal);
HRESULT SetDistributionServer(SQLDMO_LPCSTR NewValue);
Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.