Dela via


Article.VerticalPartition Property

Specifies whether all columns are published in a table article.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public ReadOnly Property VerticalPartition As Boolean
    Get
'Usage
Dim instance As Article
Dim value As Boolean

value = instance.VerticalPartition
public bool VerticalPartition { get; }
public:
property bool VerticalPartition {
    bool get ();
}
member VerticalPartition : bool
function get VerticalPartition () : boolean

Property Value

Type: System.Boolean
A Boolean value. If the value is true, columns must be added to the article after the article is created. If the value is false, all table columns are included in the article.

Remarks

The VerticalPartition property is a read-only property.

The VerticalPartition property can be retrieved by members of the sysadmin fixed server role at the Publisher and at the Subscriber (for republishing Subscribers). It can also be retrieved by members of the db_owner fixed database role on the publication database and by users who are members of the PAL. For a MergeArticle object, this property can also be retrieved by members of the replmonitor fixed database role on the Distributor.

Retrieving VerticalPartition is equivalent to executing sp_helparticle (Transact-SQL) for transactional or snapshot replication or executing sp_helpmergearticle (Transact-SQL) for merge replication.

The VerticalPartition property is available with SQL Server 2005, SQL Server 2000, and SQL Server 7.0.

This namespace, class, or member is supported only in the .NET Framework 2.0.