Share via


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.

See Also

Reference

MergePublication Class

Microsoft.SqlServer.Replication Namespace