Syntax

object.DynamicFilterHostName [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

String that sets or returns the hostname

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDynamicFilterHostName(SQLDMO_LPBSTR pRetVal);

HRESULT SetDynamicFilterHostName)(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 using SysFreeString.

Remarks

The DynamicFilterHostName property should be the same as the host_name() of the Publisher connection that the Merge agent uses for evaluating the dynamic filters at the Publisher. This is usually equivalent to the Subscriber machine name if the Merge agent is running on the Subscriber machine.

After the MergeDynamicSnapshotJob is created, the DynamicFilterHostName property cannot be modified.

Note  DynamicFilterHostName can be used only with Microsoft® SQL Server™ 2000.