Jaa


Article.Remove Method

Removes an existing article on the currently connected instance of SQL Server based on the current properties of the TransArticle object or the MergeArticle object.

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

Syntax

'Declaration
Public Sub Remove
public void Remove ()
public:
void Remove ()
public void Remove ()
public function Remove ()

Remarks

The Remove method can be called by members of the sysadmin fixed server role at the Publisher. It can also be called by members of the db_owner fixed database role on the publication database.

Calling Remove is equivalent to executing sp_droparticle (Transact-SQL) for transactional or snapshot replication or executing sp_dropmergearticle (Transact-SQL) for merge replication.

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.

See Also

Reference

Article Class
Article Members
Microsoft.SqlServer.Replication Namespace

Other Resources

How to: Delete an Article (RMO Programming)