title: SQL Server trigger on replication
body: <p>I need to create a SQL Server database that will recieve updates by some replication mechanism from another database. I need to write insert, update and delete triggers that will execute when this replilcation occurs.</p>
  
  <p>I have experience with triggers but not with replication.</p>
  
  <p>Should I use Transactional or Merge replication, or does it matter?</p>
  
  <p>Will a trigger designed to run when a simple SQL insert statement is executed also run when replication occurs?</p>