ASE : Removing the Replication Marker or Transaction Log Marker

When loading a database from a database which was replicated, it is necessary
to remove the replication transaction log marker - otherwise a good chunk
of the transaction log will go to waste (and may cause log-full situations

1> dbcc gettrunc
2> go
secondary trunc page secondary trunc state dbrepstat generation id database id database name ltl version
-------------------- --------------------- --------- ------------- ----------- ------------------------------ -----------
45626 1 167 0 16 database702 400


1> dbcc settrunc(ltm,ignore)
2> go
secondary trunc page secondary trunc state dbrepstat generation id database id database name ltl version
-------------------- --------------------- --------- ------------- ----------- ------------------------------ -----------
45626 0 166 0 16 database702 400