Article.VerticalPartition Property

Article
12/03/2008

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

public bool VerticalPartition { get; }

public:
property bool VerticalPartition {
    bool get ();
}

/** @property */
public boolean get_VerticalPartition ()

public function get VerticalPartition () : boolean

Property Value

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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via