This topic has not yet been rated - Rate this topic

TransArticle.AddReplicatedColumns Method

SQL Server 2008 R2

Other Versions

Includes columns in a vertically partitioned table article.

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

Syntax

C++

JScript

public void AddReplicatedColumns(
	Array columns
)

Parameters

columns: Type: System.Array
An array of String values that represent the columns to be included in the article.

Remarks

Passing a null value for columns includes all columns.

The AddReplicatedColumns method is only available when working with instances of SQL Server 2000 and SQL Server 2005.

The AddReplicatedColumns method can only be called by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

Calling AddReplicatedColumns is equivalent to executing sp_articlecolumn and sp_articleview.

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

Reference

TransArticle Class

Microsoft.SqlServer.Replication Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD