PublicationMonitor.CleanUpTracerTokenHistory Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Removes metadata for tracer tokens from a database published using transactional replication.
Overloads
CleanUpTracerTokenHistory(DateTime) |
Removes all metadata for tracer tokens older than the specified date from a database published using transactional replication. |
CleanUpTracerTokenHistory(Int32) |
Removes metadata for a specific tracer token from a database published using transactional replication. |
CleanUpTracerTokenHistory(DateTime)
Removes all metadata for tracer tokens older than the specified date from a database published using transactional replication.
public:
void CleanUpTracerTokenHistory(DateTime cutoffTime);
public void CleanUpTracerTokenHistory (DateTime cutoffTime);
member this.CleanUpTracerTokenHistory : DateTime -> unit
Public Sub CleanUpTracerTokenHistory (cutoffTime As DateTime)
Parameters
- cutoffTime
- DateTime
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.
Applies to
CleanUpTracerTokenHistory(Int32)
Removes metadata for a specific tracer token from a database published using transactional replication.
public:
void CleanUpTracerTokenHistory(int tracerTokenId);
public void CleanUpTracerTokenHistory (int tracerTokenId);
member this.CleanUpTracerTokenHistory : int -> unit
Public Sub CleanUpTracerTokenHistory (tracerTokenId As Integer)
Parameters
- tracerTokenId
- Int32
The ID of the tracer token to remove from the publication database and all subscription databases. Use the EnumTracerTokens() method to return all existing tracer tokens for a monitored publication.
Remarks
The CleanUpTracerTokenHistory(Int32) method is supported only with transactional replication.
The CleanUpTracerTokenHistory(Int32) 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(Int32) is equivalent to executing sp_deletetracertokenhistory (Transact-SQL) at the Distributor.