Publication.Remove Method (Boolean)

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 _
)
'Usage
Dim instance As Publication
Dim force As Boolean

instance.Remove(force)
public void Remove(
    bool force
)
public:
void Remove(
    bool force
)
member Remove : 
        force:bool -> unit 
public function Remove(
    force : boolean
)

Parameters

  • force
    Type: System.Boolean
    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.