Share via

PublicationMonitor.CleanUpTracerTokenHistory Method (DateTime)

  • Article

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.

See Also

Reference

PublicationMonitor Class

CleanUpTracerTokenHistory Overload

Microsoft.SqlServer.Replication Namespace

Other Resources

NIB Measure Latency and Validate Connections for Transactional Replication (RMO Programming)

Measure Latency and Validate Connections for Transactional Replication