CleanUpTracerTokenHistory Method (DateTime)
Collapse the table of content
Expand the table of content

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)

public void CleanUpTracerTokenHistory(
	DateTime cutoffTime
)

Parameters

cutoffTime
Type: System.DateTime

A DateTime value that specifies the date and time before which to remove the tracer token history records.

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.

Return to top
Show:
© 2016 Microsoft