In transactional repliction When you register a subscriber and run the snap shot agent at the first time, it will create 3 store procedures for each table for insert, update and delete. You can either use those standard store procedures or you can customised those procedures.