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 _
)
'Usage
Dim instance As DistributionDatabase
Dim agentId As Integer
Dim publicationType As PublicationType
instance.CleanUpAnonymousSubscription(agentId, _
publicationType)
public void CleanUpAnonymousSubscription(
int agentId,
PublicationType publicationType
)
public:
void CleanUpAnonymousSubscription(
int agentId,
PublicationType publicationType
)
member CleanUpAnonymousSubscription :
agentId:int *
publicationType:PublicationType -> unit
public function CleanUpAnonymousSubscription(
agentId : int,
publicationType : PublicationType
)
Parameters
- agentId
Type: System.Int32
An Int32 value that specifies the agent ID value.
- publicationType
Type: Microsoft.SqlServer.Replication.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.