Share via

Publication.Remove Method (Boolean)

  • Article

Removes an existing publication even if the Distributor cannot be accessed.

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

Syntax

'Declaration
Public Sub Remove ( _
    force As Boolean _
)

public void Remove (
    bool force
)

public:
void Remove (
    bool force
)

public void Remove (
    boolean force
)

public function Remove (
    force : boolean
)

Parameters

  • force
    A Boolean value that indicates whether or not a publication can be removed even if the Distributor cannot be accessed. Specify a value of true to remove a publication when the Distributor is offline or when reinstalling the Distributor.

Remarks

The Remove 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 Remove is equivalent to executing sp_droppublication (Transact-SQL) or sp_dropmergepublication (Transact-SQL).

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

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

Publication Class
Publication Members
Microsoft.SqlServer.Replication Namespace

Other Resources

How to: Delete a Publication (RMO Programming)
How to: Delete a Publication (RMO Programming)