• Article

DistributionDatabase Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The DistributionDatabase property identifies the Microsoft SQL Server database used by a Distributor or DistributionPublisher object as a workspace.

Syntax

object
.DistributionDatabase [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    The name of an existing SQL Server database

Data Type

String

Modifiable

Read/write for a DistributionPublisher object; read-only for a Distributor object.

Prototype (C/C++)

HRESULT GetDistributionDatabase(SQLDMO_LPBSTR pRetVal);
HRESULT SetDistributionDatabase(SQLDMO_LPCSTR NewValue);

Note

SQL Distributed Management Objects (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 using SysFreeString.