HostName Property (Replication ActiveX)
The HostName property returns or sets the host name used when connecting to the Publisher. This property provides a value used when the publication is dynamically filtered using the SQL Server HOST_NAME (Transact-SQL) function.
Syntaxe
object.HostName [= value]
| Part | Description |
|---|---|
object |
Expression that evaluates to a SQLMerge object. |
value |
Value to be returned by HOST_NAME (Transact-SQL) in filter clauses. |
Applies To
Notes
Use the HostName property to set a value for HOST_NAME (Transact-SQL) in dynamic filtering. For example, if the subset filter clause LoginID = HOST_NAME() has been specified for an article, and if you set the HostName property to "adventure-works\garrett1" before calling the Run Method (Replication ActiveX) method of the SQLMerge Object (Replication ActiveX) object, only rows having "adventure-works\garrett1" in the LoginID column will participate in the replication of that article.
The case of the HostName property is only ignored when both the Publisher and the publication database are configured as case insensitive.
Data Type
String
Modifiable
Read/write
Prototype C/C++
HRESULT get_HostName(BSTR *pVal);
HRESULT put_HostName(BSTR newVal);