Partilhar via


DistributionDatabase.CleanUpAnonymousSubscription Method

Removes metadata for anonymous subscriptions at the Distributor.

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

Syntax

'Declaration
Public Sub CleanUpAnonymousSubscription ( _
    agentId As Integer, _
    publicationType As PublicationType _
)
public void CleanUpAnonymousSubscription (
    int agentId,
    PublicationType publicationType
)
public:
void CleanUpAnonymousSubscription (
    int agentId, 
    PublicationType publicationType
)
public void CleanUpAnonymousSubscription (
    int agentId, 
    PublicationType publicationType
)
public function CleanUpAnonymousSubscription (
    agentId : int, 
    publicationType : PublicationType
)

Parameters

  • agentId
    An Int32 value that specifies the agent ID value.
  • publicationType
    A PublicationType object value that specifies the publication type.

Remarks

Use the CleanUpAnonymousSubscription method to remove the metadata for anonymous subscriptions that have expired or that no longer exist. Otherwise, this metadata may be returned by Replication Monitor. You can also use the ExcludeAnonymousSubscriptions property to prevent anonymous subscription information from being returned. For more information, see Monitoring Replication with Replication Monitor.

The CleanUpAnonymousSubscription method can only be called by members of the db_owner fixed database role on the distribution database.

The CleanUpAnonymousSubscription method can only be used with SQL Server 2000 or later.

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

DistributionDatabase Class
DistributionDatabase Members
Microsoft.SqlServer.Replication Namespace