MergePublication.UsesHostName Property
Gets a value that indicates whether the merge publication has a parameterized row filter that uses the HOST_NAME function to evaluate the partition.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public ReadOnly Property UsesHostName As Boolean
Get
'Usage
Dim instance As MergePublication
Dim value As Boolean
value = instance.UsesHostName
public bool UsesHostName { get; }
public:
property bool UsesHostName {
bool get ();
}
member UsesHostName : bool
function get UsesHostName () : boolean
Property Value
Type: System.Boolean
true if the merge publication uses the HOST_NAME function to evaluate the partition; false if the merge publication does not use the HOST_NAME function to evaluate the partition.
Exceptions
| Exception | Condition |
|---|---|
| ApplicationException | When the publication does not exist at the Publisher. When the version is not Microsoft SQL Server 2005 or later. |
Remarks
The UsesHostName property can be retrieved by members of the db_owner or replmonitor fixed database roles on the publication database or by members of the publication access list (PAL) for the publication.
Retrieving UsesHostName is equivalent to executing sp_helpmergepublication.