Mixed-mode transactions

If a single transaction that invokes one or more request stored procedures is a mixed-mode transaction that also executes applied stored procedures or contains data modification language, Replication Server processes the request stored procedures after all the other operations. All request operations are processed together in a single separate transaction. This situation may arise where a single Replication Server manages both primary and replicate data.