• Article

PublicationMonitor.CleanUpTracerTokenHistory Method (DateTime)

Removes all metadata for tracer tokens older than the specified date from a database published using transactional replication.

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

Syntax

'Declaration
Public Sub CleanUpTracerTokenHistory ( _
    cutoffTime As DateTime _
)
'Usage
Dim instance As PublicationMonitor
Dim cutoffTime As DateTime

instance.CleanUpTracerTokenHistory(cutoffTime)

public void CleanUpTracerTokenHistory(
    DateTime cutoffTime
)

public:
void CleanUpTracerTokenHistory(
    DateTime cutoffTime
)

member CleanUpTracerTokenHistory : 
        cutoffTime:DateTime -> unit 

public function CleanUpTracerTokenHistory(
    cutoffTime : DateTime
)

Parameters

  • cutoffTime
    Type: System.DateTime
    A DateTime value that specifies the date and time before which to remove the tracer token history records.

Remarks

The CleanUpTracerTokenHistory(DateTime) method is supported only with transactional replication.

The CleanUpTracerTokenHistory(DateTime) method can only be called by members of the sysadmin fixed server role on the Distributor or by members of the db_owner or replmonitor fixed database roles in the distribution database.

Calling CleanUpTracerTokenHistory(DateTime) is equivalent to executing sp_deletetracertokenhistory (Transact-SQL) at the Distributor.

The CleanUpTracerTokenHistory(DateTime) method is available with SQL Server 2005 only.

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