Stored procedures created by replication regeneration

After you create your replication categories and rules, and you have regenerated the replication triggers, the generation process runs the ReplicationTriggerDelCodeSp stored procedure and the ReplicationTriggerIupCodeSp stored procedure.

For each table that is included in a replication category and rule, these stored procedures look up the table’s schema on the current database and then create the replication table triggers and these stored procedures:

  • ReplIup_TableName_SourceSite_DestinationSiteSp
  • ReplDel_TableName_SourceSite_DestinationSiteSp

These newly created stored procedures use table-specific INSERT or UPDATE statements to actually perform the replication.